=IF(B1="kb",A3, IF(B1="mb",A1*1000,A1*1000000))
-- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Thu, May 7, 2020 at 4:56 PM Wade Smart <wadesm...@gmail.com> wrote: > > =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 <bjloc...@lockie.ca> 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: users+unsubscr...@global.libreoffice.org > > 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: users+unsubscr...@global.libreoffice.org 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