Adding another condition/outcome to a formula

Andreamary
Andreamary used Ask the Experts™
on
In column AF, the cells are automatically populated with "ERR" if the criteria in this formula is met:

=IF(OR($AS2="ERR",$BB2="ERR",$BE2="ERR"),"ERR","")

I need to revise the formula to include the following criteria and outcome below:

If AS2 and/or BB2 and/or BE2 is equal to "CORR" and AS2 and/or BB2 and/or BE2 is not equal to "ERR", then populate AF2 with "CORR".

Thanks,
Andrea
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2013
Commented:
Hello Andrea, try adding another OR

=IF(OR($AS2="ERR",$BB2="ERR",$BE2="ERR"),"ERR",IF(OR($AS2="CORR",$BB2="CORR",$BE2="CORR"),"CORR",""))

regards, barry

Author

Commented:
Perfect! Thanks so much...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial