IF Statement using multiple conditions

[xsiededios]

Hi,

I'm trying to figure out an =IF statement to return a value of 0 if there is a least one of the three cells contains "not valid", 1 if all the three cells contains 'valid", and 2 if all the three cells containing "potential" or "Valid".

1. Valid Valid Valid =1
2. Potential Potential Valid =2
3. Potential Valid Valid =2
4. Valid Invalid Invalid = 0

Please help. Thanks

[Spitzerpl]

Try

Please Login or Register  to view this content.

Hope it works. I'm not at a computer.

Phil

[Marcol]

Maybe this shorter formula

Please Login or Register  to view this content.

[xsiededios]

Thank you. I tried this and it Works!