Solved

Adding another condition/outcome to a formula

Posted on 2014-02-27
175 Views
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
0
Question by:Andreamary
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 50

Accepted Solution

barry houdini earned 500 total points
ID: 39893582
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
0

Author Closing Comment

ID: 39893666
Perfect! Thanks so much...
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
Gain an elementary understanding of Blockchain technology.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Suggested Courses
Course of the Month10 days, 17 hours left to enroll