ANDing values in excel

[Ramesha]

Hi Friends:

I, do not know what is wrong in the enclosed excel formula, pl suggest(as usual I'm not able to upload excel, as I, do not see the file while trying to enclose, hence enclosing renamed file in docx)

Thanks,

 

[Chihiro]

You should nest AND in IF statement to return "OK" if AND condition is TRUE and "NOK" if it's FALSE.

As well, you need text value your are checking inside AND in "".

=IF(AND(A3="OK",B3="OK",C3="OK",D3="OK"),"OK","NOK")

Alternate method

=IF(SUMPRODUCT(--(A3:D3="OK"))=4,"OK","NOK")

 

[Khalid NGO]

Hi,
Another:

=IF(A3&B3&C3&D3=REPT("OK",4),"OK","NOK")

=IF(COUNTIF(A3:D3,"OK")=4,"OK","NOK")

Regards,

 

[Ramesha]

You should nest AND in IF statement to return "OK" if AND condition is TRUE and "NOK" if it's FALSE.

As well, you need text value your are checking inside AND in "".

=IF(AND(A3="OK",B3="OK",C3="OK",D3="OK"),"OK","NOK")

Alternate method

=IF(SUMPRODUCT(--(A3:D3="OK"))=4,"OK","NOK")

Thanks

 

[Ramesha]

Hi,
Another:

=IF(A3&B3&C3&D3=REPT("OK",4),"OK","NOK")

=IF(COUNTIF(A3:D3,"OK")=4,"OK","NOK")

Regards,

THanks

 

[Vijay Dhangar]

Use array formula

=IF(AND(A3:D3="OK"),"OK","NOK")
(ctrl+shift+enter)

 

[Ramesha]

Thanks a lot

 

[Ramesha]

Use array formula

=IF(AND(A3:D3="OK"),"OK","NOK")
(ctrl+shift+enter)

I, do not know why (ctrl+shift+enter) to be used! it would be a learning to understand it.

 

[bobhc]

http://www.excel-easy.com/functions/array-formulas.html