Forum Discussion
Need Help with Microsoft IF Formula
I can only guess where it might go wrong.
=IF(OR(O64="External",AND(O64="NUS-Adjunct",G64="School of Business",0,S64*0.1)
There should be an equal number of opening and closing parentheses. But you have three opening and only one closing. IF that's the issue (although it's possible you just didn't copy it here as it really is) the formula should read
=IF(OR(O64="External",AND(O64="NUS-Adjunct",G64="School of Business")),0,S64*0.1)
If that's not the case, maybe you could be more descriptive on exactly how it's not working. Is it delivering no result, a wrong result (if so, what wrong result)? And so forth. "Not working" is too vague to make a diagnosis.
See the attached. The formula you requested is as follows
=IF(OR([@Status]="External",AND([@Status]="Adjunct",[@School]="Business")),0,[@[Faculty Fee]]*0.1)
However, if in fact that was just scratching the surface, IF, that is, you have still more conditions that need to be handled, it would be far better to create a table and a formula that accesses the table to determine what action to take. IF formulas, when too many possible combinations are involved, can get indecipherable and thereby unreliable. Even if they work as desired at the start, a small policy change can wreak havoc.
- Actually, this is the Formula I did using your Example above :
=IF(OR(O64="External",AND(O64="NUS-Adjunct",G64="School of Business",0,S64*0.1)
But it does not work 😞 Can you tell me where I am going wrong ?I can only guess where it might go wrong.
=IF(OR(O64="External",AND(O64="NUS-Adjunct",G64="School of Business",0,S64*0.1)
There should be an equal number of opening and closing parentheses. But you have three opening and only one closing. IF that's the issue (although it's possible you just didn't copy it here as it really is) the formula should read
=IF(OR(O64="External",AND(O64="NUS-Adjunct",G64="School of Business")),0,S64*0.1)
If that's not the case, maybe you could be more descriptive on exactly how it's not working. Is it delivering no result, a wrong result (if so, what wrong result)? And so forth. "Not working" is too vague to make a diagnosis.
- Thank you so much !!!!!!! It works !!! Hooray ! Thank you ! You are amazing !
