how do you freeze multiple rows? On Wed, Mar 11, 2020 at 4:01 PM Michael wrote: > > I like yours better. it is shorter. > > On Tue, Mar 10, 2020 at 2:48 PM Craig Whipp wrote: > > > > It looks like you already have a working solution, but you might try: > > > > =max((H3/I3)-(15*0.55); 0) > > > > -------- Original message -------- > > From: Michael > > Date: 3/8/20 10:01 PM (GMT-07:00) > > To: Main PLUG discussion list > > Subject: Re: librecalc > > > > 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 > > > > -- > > :-)~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~(-: -- :-)~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