| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extended IF Formula
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 |
| 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
