that worked (I think). Thank you so much. I say 'think' because the answer
I got was 200. Odd to get a round number like that.
On Fri, Nov 22, 2024 at 2:03 PM Brian Cluff via PLUG-discuss <
plug-discuss@lists.phxlinux.org> wrote:
> If I understand what you are trying to do, try this:
>
> =COUNTA
If I understand what you are trying to do, try this:
=COUNTA($A.A:A,$B.A:A,$C.A:A,$D.A:A,$E.A:A,$F.A:A,$G.A:A,$H.A:A,$I.A:A,$J.A:A,$K.A:A,$L.A:A,$M.A:A,$N.A:A,$O.A:A,$P.A:A,$Q.A:A,$R.A:A,$S.A:A,$T.A:A,$U.A:A,$V.A:A,$W.A:A,$X.A:A,$Y.A:A,$Z.A:A)
This is basically over and over $A.A:A. The $A is ju
Here is the response I get from the paid version (4o):
=
To count all entries in column A across multiple sheets in LibreOffice
Calc, you can use the SUMPRODUCT and COUNTIF functions in combination.
Here's how you can do it:
Step-by-Step Solution:
1. Name Your Sheets: Ens
chapgpt doesn't know what it's talking about. how do I count all entries in
column A across all sheets in libre calc? the sheets are A B C D E F G H I
J K L M N P R S T V W .
The formula it gives me is saying 20 when I know there is over 100. Here is
the formula it gives me:
=COUNTA(a.a) + COUNTA(
They have to be in linear sections, or you have to get creative with
formulas or such. Or if just that weird and discontiguous, manually
grabbing bits with old cut/paste and a mouse click.
You'll want to learn to use at least basic (and not so basic) formulas if
you are at that point. I use calc
I want to copy multiple selections but it won't let me. How do you do it if
you can?
--
:-)~MIKE~(-:
---
PLUG-discuss mailing list: PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
https://lists.phxlinux.or
I fixed it. I wish they would pay attention to math rules! I got it to work
like this:
=ROUNDDOWN(((D365-C365)*($N$125)*0.01)*1.5+(((F365-E365)*0.01*($P$125))*1.5),2)
On Fri, Mar 3, 2023 at 11:41 AM Michael wrote:
> here is my formula:
>
> =ROUNDDOWN(((D191-C191)*($N$125)*0.01+((F191-E191)*0.01
here is my formula:
=ROUNDDOWN(((D191-C191)*($N$125)*0.01+((F191-E191)*0.01*($P$125))*1.5),2)
when I plug in 0ne hour of time it gives me straight pay, not the holiday
pay of 1.5 times what, pray tell, have I done wrong?
--
:-)~MIKE~(-:
---
PLUG-
> > =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
M (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 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
that if statement is just what the doctor ordered
On Mon, Mar 9, 2020 at 2:28 AM Joseph Sinclair
wrote:
>
> 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.5
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 tr
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 wh
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
s
HI 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:
> mi
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!
>
> O
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
> >
> > --
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~(-:
---
PLUG-discuss mailing list -
how do wwe get it to not give a negative value
--
:-)~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
20 matches
Mail list logo
