 # excel if statement question

I am trying to make an if statement in excel that has 3 outcomes (not even sure if thats possible?)

this is what I have so far

=IF(OR(AND(A50=\$A\$32,C50=\$C\$32, E50=\$E\$32, E50<>"UD"),AND(A50=\$A\$32,C50=\$C\$32, E50=\$E\$32)),20,10)

If AND(A50=\$A\$32,C50=\$C\$32, E50=\$E\$32, E50<>"UD") is true I want the cell to be 20
if AND(A50=\$A\$32,C50=\$C\$32, E50=\$E\$32) is true I want the cell to be 10
if neither are true I want the cell to be 0

right now the 10 / 20 is swapped?... I dont understand why that is?..

and I dont know how to add the condition for 0

Thanks
Microsoft ExcelMicrosoft Office Last Comment
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

8/22/2022 - Mon
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
jppinto

TRy like this:

=IF(AND(A50=\$A\$32,C50=\$C\$32,E50=\$E\$32,E50<>"UD"),20,IF(AND(A50=\$A\$32,C50=\$C\$32,E50=\$E\$32),10,0))
bail3yz