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 <bjlockie@lockie.ca> 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: users+unsubscribe@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+unsubscribe@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