Make sure there is no spaces at all in the C column. I removed all formatting and your formula result is .014648438
-- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Sun, May 17, 2020 at 3:42 PM Wade Smart <[email protected]> wrote: > > When I format C as text or all it displays FALSE, not true. > > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > On Sun, May 17, 2020 at 3:35 PM James <[email protected]> wrote: > > > > A B C D E > > 3/10/2020 15 KB 0 15 > > > > E1 contains this: > > =IF(C3="KB",B3/1024,B3) > > It displays 15 > > > > I tried: > > =IF(C3="KB") > > It displays TRUE > > > > My formula works elsewhere. > > Any ideas? > > > > > > > > -- > > 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
