librecalc

[Michael]

That is what I want. I want the answer to be not a negative number
if it is a negative number it needs to be zero.

On Mon, Mar 9, 2020 at 12:40 AM Joseph Sinclair <plug-discussion at stcaz.net>
wrote:

> It is not clear your exact equation goal.
> Here is one interpretation of your equation: =(H3/I3)-(15*0.55) <== This
> is what it currently does, with order of operations.  With 1 and 1 it
> produces 1-8.25, which is -7.25.
> Here is another, what you *might* intend: =H3/((I3-15)*0.55)  <== This
> would still be negative if I3 < 15, but it *might* be closer to what you
> intended....  This would, with 1 and 1, produces −0.12987013
>
> As you can see, the order of the equation makes a large difference, and I
> do not know what the intent is.
>
> To make it not negative, first you probably need numbers in columns H and
> I that are larger.  Beyond that, you *could* use the ABS() function to
> force the value to non-negative, but that also may not produce the correct
> results...
>
>
>
> On 2020-03-07 05:59 PM, Michael wrote:
> >    H        I                  J                   K
> > miles shoots vrtuanc mileage fed mileage
> > 1             1           -7.25             -0.18125
> > virtuance mileage equation =H3/I3-15*0.55
> > fed mileage equation=J3*0.025
> >
> > On Sat, Mar 7, 2020 at 7:52 PM Michael <bmike1 at gmail.com> wrote:
> >>
> >> here is what I'm doing:
> >> miles shoots vrtuanc mileage fed mileage
> >> 1             1           -7.25             -0.18125
> >> virtuance mileage equation =H3/I3-15*0.55
> >> fed mileage equation=J3*0.025
> >>
> >> On Sat, Mar 7, 2020 at 7:46 PM Michael <bmike1 at gmail.com> wrote:
> >>>
> >>> oops... the info is still needed. Sorry about that!
> >>>
> >>> On Sat, Mar 7, 2020 at 7:30 PM Michael <bmike1 at gmail.com> wrote:
> >>>>
> >>>> never mind. I didn't find out how to do it but the info is no longer
> necessary
> >>>>
> >>>> On Sat, Mar 7, 2020 at 6:59 PM Michael <bmike1 at gmail.com> wrote:
> >>>>>
> >>>>> how do wwe get it to not give a negative value
> >>>>>
> >>>>> --
> >>>>> :-)~MIKE~(-:
> >>>>
> >>>>
> >>>>
> >>>> --
> >>>> :-)~MIKE~(-:
> >>>
> >>>
> >>>
> >>> --
> >>> :-)~MIKE~(-:
> >>
> >>
> >>
> >> --
> >> :-)~MIKE~(-:
> >
> >
> >
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> https://lists.phxlinux.org/mailman/listinfo/plug-discuss

-- 
:-)~MIKE~(-:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phxlinux.org/pipermail/plug-discuss/attachments/20200309/6dfcb45c/attachment.html>