Ensure Upper case, Lower case matching while using Switch ()

How to ensure the correct case matching between expression and value and result while using Switch function in libreoffice calc

Please do not ask unspecific questions. Your question seems to seek a training course with a tutorial. Instead, provide a specific task you can’t solve, like a sample ODS with a data and a formula, the description how the actual result doesn’t match your expectation, and a wanted result. That would allow answerers to see your error, and suggest a working formula.

1 Like

And please, basically you have to specify the operating system and the LibreOffice version (three digits, e.g. 7.3.2).
Furthermore, specify the file type in which you saved.

Here you can find the further References for this page.

You can’t, SWITCH() comparison of strings is case-insensitive.

Well, you could if you wrote a hash spreadsheet function that hashes both arguments and produces different hashes for different casing and do the switch on the hashes instead.