It looks like you already have a working solution, but you might try:=max((H3/I3)-(15*0.55); 0)
-------- Original message --------From: Michael <
bmike1@gmail.com> Date: 3/8/20 10:01 PM (GMT-07:00) To: Main PLUG discussion list <
plug-discuss@lists.phxlinux.org> Subject: Re: librecalc That is what I want. I want the answer to be not a negative numberif it is a negative number it needs to be zero.On Mon, Mar 9, 2020 at 12:40 AM Joseph Sinclair <
plug-discussion@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@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@gmail.com> wrote:
>>>
>>> oops... the info is still needed. Sorry about that!
>>>
>>> On Sat, Mar 7, 2020 at 7:30 PM Michael <bmike1@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@gmail.com> 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~(-:
---------------------------------------------------
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
(text/plain)