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 - PLUG-discuss@lists.phxlinux.org > >> To subscribe, unsubscribe, or to change your mail settings: > >> https://lists.phxlinux.org/mailman/listinfo/plug-discuss > > > > > > > > --------------------------------------------------- > > PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org > > To subscribe, unsubscribe, or to change your mail settings: > > https://lists.phxlinux.org/mailman/listinfo/plug-discuss > > > > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org > To subscribe, unsubscribe, or to change your mail settings: > https://lists.phxlinux.org/mailman/listinfo/plug-discuss -- :-)~MIKE~(-: --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org To subscribe, unsubscribe, or to change your mail settings: https://lists.phxlinux.org/mailman/listinfo/plug-discuss