| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOGICAL OPERATOR "IF" FOR AN ARRAY
try this :
=IF(B2="LOSANGELS","AMERICANS","NON-AMERICANS") same way u can try numbers also =if(B2<40,"fail","Pass") -- Name : K.Prasad Inventory Manager CRYSTALGALLERY DUBAI "FARAZ QURESHI" wrote: Can V have a formulas like the following? if ( any of the cells in array A1:A100 = "LOS ANGELES" , then "AMERICAN", otherwise "NON-AMERICAN") OR if ( any of the cells in array A1:A20 < "40" , then "FAIL", otherwise "PASS") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use of Offset function in array formula | Excel Worksheet Functions | |||
| logical test, array, text and numbers | Excel Worksheet Functions | |||
| Question to Bob Phillips (or whoever...) | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
