Excel Formulas - set "Perfect" if all cells are "OK"

Common problems – different language?
Let's talk in English.

Excel Formulas - set "Perfect" if all cells are "OK"

Poslaťod Palo-admin » 30.01.2010, 14:01

Sudheer Naidu posted at Tuesday, January 26, 2010 7:13 AM

Hi Friends
Im facing a problem with the small issue will u please clarify me the formula

A1 OK
A2 OK
A3 OK
A4 NO
A5 OK
A6 OK
A7 OK
A8 NO
A9 ?


here the problem with the A9, I need the value of the A9 should be Perfect when A1 to A8 are OK
if we have any one of this A1 to A8 as NO the value should be return as Pending

If u can help me i will be thankful for U friend


Hi Sudheer.

If I assume your data will be in range B3:B10
you can use this formula:
=IF(COUNTIF(B3:B10;"NO");"Pending";IF(COUNTIF(B3:B10;"OK")=8;"Perfect";"Not All Filled"))

You can also use Conditional formating for coloring values OK an NO

see example:
http://www.pc-prog.eu/phpBB3/images/xMyKB/QA.xls

QA_formula.GIF


Palo
Nemáte oprávnenie prezerať súbory priložené v tomto príspevku.
Palo-admin
Administrátor stránky
 
Príspevky: 473
Registrovaný: 18.07.2008, 16:43
Udelené poďakovania: 6 krát
Prijaté poďakovania: 63 krát

Späť na Solving MS Office problems in English

Kto je on-line

Užívatelia prezerajúci fórum: Žiadny registrovaný užívateľ nie je prítomný a 1 hosť

cron