<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body dir="auto">It looks like you already have a working solution, but you might try:<div><br><div dir="auto">=max((H3/I3)-(15*0.55); 0)</div></div><div><br></div><div style="font-size:100%;color:#000000" dir="auto"><!-- originalMessage --><div>-------- Original message --------</div><div>From: Michael <bmike1@gmail.com> </div><div>Date: 3/8/20 10:01 PM (GMT-07:00) </div><div>To: Main PLUG discussion list <plug-discuss@lists.phxlinux.org> </div><div>Subject: Re: librecalc </div><div><br></div></div><div><div dir="auto">That is what I want. I want the answer to be not a negative number</div><div dir="auto">if it is a negative number it needs to be zero.</div></div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Mar 9, 2020 at 12:40 AM Joseph Sinclair <<a href="mailto:plug-discussion@stcaz.net">plug-discussion@stcaz.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">It is not clear your exact equation goal.<br>
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.<br>
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<br>
<br>
As you can see, the order of the equation makes a large difference, and I do not know what the intent is.<br>
<br>
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...<br>
<br>
<br>
<br>
On 2020-03-07 05:59 PM, Michael wrote:<br>
> H I J K<br>
> miles shoots vrtuanc mileage fed mileage<br>
> 1 1 -7.25 -0.18125<br>
> virtuance mileage equation =H3/I3-15*0.55<br>
> fed mileage equation=J3*0.025<br>
> <br>
> On Sat, Mar 7, 2020 at 7:52 PM Michael <<a href="mailto:bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>> wrote:<br>
>><br>
>> here is what I'm doing:<br>
>> miles shoots vrtuanc mileage fed mileage<br>
>> 1 1 -7.25 -0.18125<br>
>> virtuance mileage equation =H3/I3-15*0.55<br>
>> fed mileage equation=J3*0.025<br>
>><br>
>> On Sat, Mar 7, 2020 at 7:46 PM Michael <<a href="mailto:bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>> wrote:<br>
>>><br>
>>> oops... the info is still needed. Sorry about that!<br>
>>><br>
>>> On Sat, Mar 7, 2020 at 7:30 PM Michael <<a href="mailto:bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>> wrote:<br>
>>>><br>
>>>> never mind. I didn't find out how to do it but the info is no longer necessary<br>
>>>><br>
>>>> On Sat, Mar 7, 2020 at 6:59 PM Michael <<a href="mailto:bmike1@gmail.com" target="_blank">bmike1@gmail.com</a>> wrote:<br>
>>>>><br>
>>>>> how do wwe get it to not give a negative value<br>
>>>>><br>
>>>>> --<br>
>>>>> :-)~MIKE~(-:<br>
>>>><br>
>>>><br>
>>>><br>
>>>> --<br>
>>>> :-)~MIKE~(-:<br>
>>><br>
>>><br>
>>><br>
>>> --<br>
>>> :-)~MIKE~(-:<br>
>><br>
>><br>
>><br>
>> --<br>
>> :-)~MIKE~(-:<br>
> <br>
> <br>
> <br>
<br>
---------------------------------------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.phxlinux.org" target="_blank">PLUG-discuss@lists.phxlinux.org</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a href="https://lists.phxlinux.org/mailman/listinfo/plug-discuss" rel="noreferrer" target="_blank">https://lists.phxlinux.org/mailman/listinfo/plug-discuss</a></blockquote></div></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><span style="font-size:12.8000001907349px">:-)~MIKE~(-:</span><br></div></div></div></div></div>
</body></html>