librecalc

[Joseph Sinclair]

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 <plug-discussion at stcaz.net>
> 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 <bmike1 at gmail.com> 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 <bmike1 at gmail.com> wrote:
>>>>>
>>>>> oops... the info is still needed. Sorry about that!
>>>>>
>>>>> On Sat, Mar 7, 2020 at 7:30 PM Michael <bmike1 at gmail.com> 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 <bmike1 at gmail.com> wrote:
>>>>>>>
>>>>>>> how do wwe get it to not give a negative value
>>>>>>>
>>>>>>> --
>>>>>>> :-)~MIKE~(-:
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> :-)~MIKE~(-:
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> :-)~MIKE~(-:
>>>>
>>>>
>>>>
>>>> --
>>>> :-)~MIKE~(-:
>>>
>>>
>>>
>>
>> ---------------------------------------------------
>> PLUG-discuss mailing list - PLUG-discuss at 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 at lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> https://lists.phxlinux.org/mailman/listinfo/plug-discuss
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: OpenPGP digital signature
URL: <http://lists.phxlinux.org/pipermail/plug-discuss/attachments/20200308/92e90576/attachment.sig>