Multiple IF with and or fucntion

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I am trying determine IF a statement is not true, to check if other checkboxes are checked, return another number. So if the checkbox field sHP is true, price is 10000, if its false, check to see if sAL or sAI or sDS are true, if true, price is 3000, otherwise return 0.

If([sHP]=true,10000, If(If([sAL]=true) or If([sAI]=true) or If([sDS]=true)),3000,0)

I get a formula error:

The types of the arguments or the number of arguments supplied do not meet the requirements of the function If.

The function is defined to be If (Boolean condition1, result1, ..., else-result).

Any assistance would be greatly appreciated.
Thanks
Photo of Zero Admin

Zero Admin

  • 82 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
Official Response
It looks like a syntax error.
Try this

If([sHP]=true, 10000,
If([sAL]=true or [sAI]=true or [sDS]=true, 3000,
0))