Hi James, James schrieb am 06.04.2026 um 06:15:
A1 contains the number 14023. B1 contains the formula =SWITCH(AND(A1>5000,A1<15000),20%,A1>15000,30%) B1 is showing 30% when I expected 20%. What am I doing wrong?
SWITCH is the wrong function. Use IFS instead. =IFS(AND(A1>5000,A1<15000),20%,A1>15000,30%) Kind regards, Regina -- 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
