ExcelBanter - If Statement on Excel version 2002

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Statement on Excel version 2002 (https://www.excelbanter.com/excel-discussion-misc-queries/43479-if-statement-excel-version-2002-a.html)

biz

If Statement on Excel version 2002

Could you please give me an IF statment formula re. below condition:

IF Cell B2 = "A1", "A2", "A3", then give me result in Cell B2, otherwise 0.

A1, A2, A3 are not cell numbers--they are certain ratings.
--
biz

JE McGimpsey

One way:

=IF(SUM(COUNTIF(B2,{"A1","A2","A3"})),B2,0)

In article ,
biz wrote:

Could you please give me an IF statment formula re. below condition:

IF Cell B2 = "A1", "A2", "A3", then give me result in Cell B2, otherwise 0.

A1, A2, A3 are not cell numbers--they are certain ratings.

David Hepner

In a cell other than b2 enter this formula:

=IF(OR(B2="A1",B2="A21",B2="A3"),B2,0)

"biz" wrote:

Could you please give me an IF statment formula re. below condition:

IF Cell B2 = "A1", "A2", "A3", then give me result in Cell B2, otherwise 0.

A1, A2, A3 are not cell numbers--they are certain ratings.
--
biz

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