troubleshooting Question

excel if statement question

Avatar of bail3yz
bail3yz asked on
Microsoft ExcelMicrosoft Office
4 Comments1 Solution249 ViewsLast Modified:
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

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros