| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extended IF Formula
=IF(AND(A890,OR(I89="w",J89="C")),A89,"0")
"Barny" wrote: I use this formula to return the value in cell if the criteria is met but I would like to extend this to say that the value is also returned if cell J89 = ("C") i.e. either or I89 = W or J89 = C. =IF(AND(A890,I89="w"),A89,"0") Hope that makes sense -- Barny . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array extended formula - sort | Excel Worksheet Functions | |||
| extended List box | New Users to Excel | |||
| Auto Extended Formula not working | Excel Discussion (Misc queries) | |||
| Extended Selection | Excel Discussion (Misc queries) | |||
| Geo mean extended | Excel Worksheet Functions | |||
Threaded Mode
