asked on
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=$
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
this is what I have so far
=IF(OR(AND(A50=$A$32,C50=$
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)
ASKER CERTIFIED SOLUTION
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.
ASKER
Thank you!.. I almost figured that out myself :)
never used excel much.. not sure why I was using OR :)
Thanks again
never used excel much.. not sure why I was using OR :)
Thanks again
Or, shorter
=IF(AND(A50=$A$32,C50=$C$3
=IF(AND(A50=$A$32,C50=$C$3
=IF(AND(A50=$A$32,C50=$C$3