This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello all :slightly_smiling_face:
I’m trying to work out a formula that establishes whether to charge VAT on a product or not but can’t seem to get the IF/AND/OR statement correct.
The conditions that I require are as follows:
If Gender is equal to...
Oh wow! You guys are fantastic, thank you very much!
@Jeremy_Oglesby Using the SWITCH() function really helps to break it down and makes perfect sense. Interestingly the final 20 at the end resulted in an error and wouldn’t let me save the formula ho...
