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