Hello,
I just realised I messed up since I did not think about the
units.Considering:
1 GB = 1024 MB1 MB = 1024 KB
you can change the formula like this:
=SUM(IFERROR(VALUE(SUBSTITUTE(A2:A29,"
KB","")),0),IFERROR(VALUE(SUBSTITUE(A2:A29,"
MB",""));0)*1024,IFERROR(VALUE(SUBSTITUE(A2:A29,"
Hi,
If your values takes up, for instance the range A2 to A29, you can
enter this formula as an array formula:
=SUM(VALUE(SUBSTITUTE(SUBSTITUTE(A2:A29," KB","")," MB","")))
The only trick is to hit CTRL-SHIFT-ENTER instead of just ENTER at the
end of the formula entry: if you only use ENTER, this
On 2020-05-07 6:04 p.m., Remy Gauthier wrote:
Hi,
If your values takes up, for instance the range A2 to A29, you can
enter this formula as an array formula:
=SUM(VALUE(SUBSTITUTE(SUBSTITUTE(A2:A29," KB","")," MB","")))
The only trick is to hit CTRL-SHIFT-ENTER instead of just ENTER at the
end of
=IF(B1="kb",A3, IF(B1="mb",A1*1000,A1*100))
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Thu, May 7, 2020 at 4:56 PM Wade Smart wrote:
>
> =if(B1="MB,A1*1000,A1*??)
>
> You just change the final A1 to multiple by another number.
>
> --
>
=if(B1="MB,A1*1000,A1*??)
You just change the final A1 to multiple by another number.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Thu, May 7, 2020 at 4:46 PM James wrote:
>
> On 2020-05-07 4:17 p.m., Malcolm Jaros wrote:
> > In Cell C1 put
On 2020-05-07 4:17 p.m., Malcolm Jaros wrote:
In Cell C1 put =IF(B1="MB",A1*1000,A1)
How can I have 2 IFs in case there are GBs?
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting
Copy your data into a txt file. Open with your
spreadsheet, separate by space to put numbers
in Col A and Kb/mb in Col b. Col c = A1*1000 to get
total kb. The sum up the whole thing. Divide the total
by 1000 to get mb.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux
Correction
Last line should read
Save as *.ods file
Regards, MalJaros
- Original Message -
From: "maljaros"
To: "Global Users@"
Sent: Thursday, 7 May, 2020 22:00:43
Subject: Fwd: [libreoffice-users] sum text column of common unit of measure
numbers
Hi James
>My cell phone provider
Hi James
>My cell phone provider only provides me a CSV with a text field for the
>usage.
>I want to =sum( it so I need it to be numbers.
>Is a macro the easiest way to make a new column of common unit of
>measure (GB?) numbers?
>
>15 KB
>5 KB
>10 KB
>15 KB
>5 KB
>5 KB
>5 KB
>1.8 MB
>5 KB
>5 KB
My cell phone provider only provides me a CSV with a text field for the
usage.
I want to =sum( it so I need it to be numbers.
Is a macro the easiest way to make a new column of common unit of
measure (GB?) numbers?
15 KB
5 KB
10 KB
15 KB
5 KB
5 KB
5 KB
1.8 MB
5 KB
5 KB
15 KB
215 KB
130.2 MB
Hi Guys and Gals,
I have two feature suggestions.
They deal with the same issue, but in different ways.
The intent of both suggestions is to allow the user to limit the number of
objects / text entities / shapes etc. that are available for editing when a PDF
is opened in the LibreOffice
On 06.05.20 17:01, John Kaufmann wrote:
> None of that gets to clarity on my original question, about the relationship
> between a style's Organizer tab "Contains" section and the attributes defined
> in the style...
Don't get this but maybe this proposal might shed some light
12 matches
Mail list logo