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 >