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 -- :-)~MIKE~(-: