Re: librecalc

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Michael
Date:  
To: Main PLUG discussion list
Subject: Re: librecalc
that if statement is just what the doctor ordered

On Mon, Mar 9, 2020 at 2:28 AM Joseph Sinclair
<> wrote:
>
> Again, this depends on your correct equation, as what is there right now might not be quite what you intend.
>
> you could do a simple if.
> =IF(((H3/I3)-(15*0.55)) > 0; ((H3/I3)-(15*0.55)) ; 0)
> You'll want to adjust the parentheses above to ensure the correct grouping of operations for what you're trying to calculate.
>
> On 2020-03-08 10:01 PM, Michael wrote:
> > 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 <>
> > 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 <> 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 <> wrote:
> >>>>>
> >>>>> oops... the info is still needed. Sorry about that!
> >>>>>
> >>>>> On Sat, Mar 7, 2020 at 7:30 PM Michael <> 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 <> wrote:
> >>>>>>>
> >>>>>>> how do wwe get it to not give a negative value
> >>>>>>>
> >>>>>>> --
> >>>>>>> :-)~MIKE~(-:
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>> --
> >>>>>> :-)~MIKE~(-:
> >>>>>
> >>>>>
> >>>>>
> >>>>> --
> >>>>> :-)~MIKE~(-:
> >>>>
> >>>>
> >>>>
> >>>> --
> >>>> :-)~MIKE~(-:
> >>>
> >>>
> >>>
> >>
> >> ---------------------------------------------------
> >> PLUG-discuss mailing list -
> >> To subscribe, unsubscribe, or to change your mail settings:
> >> https://lists.phxlinux.org/mailman/listinfo/plug-discuss
> >
> >
> >
> > ---------------------------------------------------
> > PLUG-discuss mailing list -
> > To subscribe, unsubscribe, or to change your mail settings:
> > https://lists.phxlinux.org/mailman/listinfo/plug-discuss
> >
>
> ---------------------------------------------------
> PLUG-discuss mailing list -
> To subscribe, unsubscribe, or to change your mail settings:
> https://lists.phxlinux.org/mailman/listinfo/plug-discuss




--
:-)~MIKE~(-:
---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
https://lists.phxlinux.org/mailman/listinfo/plug-discuss