IF(OR Problem

[Mike Slattery]

Happy New Year Everyone:

=IF(OR(EN3=1,3,EO3=1,2,EP3=1,1,0)

I have three columns that are returning a 1 or 0 based upon a True or False condition.

If the Conditions in Cell EN3 =1, I want to return the value 3
If the Conditions in Cell E03 =1, I want to return the value 2
If the Conditions in Cell EP3 =1, I want to return the value 1

How do you handle the situation where you have more than one True condition?
What is wrong with the formula above?

Thanks for your assistance,

Michael

 

[shg]

=IF(EN3=1, 3, if(EO3=1, 2, if(EP3=1, 1, "None of the above")))

 

[Mike Slattery]

Thanks!

 

[shg]

You're welcome.