| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Analysis ToolPack For Excel 2002 | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
| Formula Arrays VERY SLOW in Excel 2002 | Excel Worksheet Functions | |||
| Can you use excel 2003 version with excel 2002 and 2000 on a netw. | Excel Discussion (Misc queries) | |||
Linear Mode
