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," GB",""));0)*1024*1024) This will give you the number of KB transferred. If you want the total in MB, just divide the SUM by 1024. I hope this helps, Rémy.
Le jeudi 07 mai 2020 à 17:09 -0500, Wade Smart a écrit : > =IF(B1="kb",A3, IF(B1="mb",A1*1000,A1*1000000)) > > -- Registered Linux User: #480675Registered Linux Machine: > #408606Linux since June 2005 > On Thu, May 7, 2020 at 4:56 PM Wade Smart <[email protected]> > wrote: > > =if(B1="MB,A1*1000,A1*??) > > You just change the final A1 to multiple by another number. > > --Registered Linux User: #480675Registered Linux Machine: > > #408606Linux since June 2005 > > On Thu, May 7, 2020 at 4:46 PM James <[email protected]> wrote: > > > 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: > > > [email protected] > > > Problems? > > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > > Posting guidelines + more: > > > https://wiki.documentfoundation.org/Netiquette > > > List archive: https://listarchives.libreoffice.org/global/users/ > > > Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
