Forum Discussion

Copper Contributor

Feb 06, 2023

Solved

Need Help with Microsoft IF Formula

I need to build an =IF Formula that will return the result as per the following permutations : Column A - Name of School Column B - Status of Faculty Column C - Faculty Fee Column D - Admin Fee...

excel

mathetes
Feb 06, 2023
Aru_1833
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.

Aru_1833

Copper Contributor

Feb 06, 2023

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 ?

mathetes

Gold Contributor

Feb 06, 2023

Aru_1833

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.

Aru_1833
Copper Contributor
Feb 06, 2023
Thank you so much !!!!!!! It works !!! Hooray ! Thank you ! You are amazing !