ExcelBanter - excel formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - excel formula (https://www.excelbanter.com/excel-worksheet-functions/254461-excel-formula.html)

sudheer

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

Max

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

Jacob Skaria

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

All times are GMT +1. The time now is 08:29 PM.