librecalc

Michael bmike1 at gmail.com
Wed Mar 11 13:45:24 MST 2020


how do you freeze multiple rows?


On Wed, Mar 11, 2020 at 4:01 PM Michael <bmike1 at gmail.com> wrote:
>
> I like yours better. it is shorter.
>
> On Tue, Mar 10, 2020 at 2:48 PM Craig Whipp <crwhipp at gmail.com> 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 <bmike1 at gmail.com>
> > Date: 3/8/20 10:01 PM (GMT-07:00)
> > To: Main PLUG discussion list <plug-discuss at lists.phxlinux.org>
> > 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 <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
> >
> > --
> > :-)~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
>
>
>
> --
> :-)~MIKE~(-:



--
:-)~MIKE~(-:


More information about the PLUG-discuss mailing list