Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula
One way
In A9: =IF(COUNTIF(A1:A8,"OK")=8,"Perfect","Pending") Yes?, hit the YES below -- Max Singapore --- "sudheer" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula
Try
=IF(COUNTIF(A1:A8,"OK")=8,"Perfect","Pending") -- Jacob "sudheer" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) |