| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining IF and OR Functions
I want to write a statement that effectively does the following:
IF Cell-value = A OR B OR C, THEN ENTER 1000 Ideally, I'd like to nest a 2nd and 3rd statement using this logic Like: IF Cell-value = A OR B OR C, then enter 1000, IF Cell-value of the same cell = D OR F, then enter 2000, IF Cell-value of that same cell = Z, then 0 Can I do this? If so, what is the proper syntax? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining VLOOKUP functions | Excel Worksheet Functions | |||
| Combining LOOKUP and COUNTIF functions | Excel Worksheet Functions | |||
| Combining COUNTIF and AND functions | Excel Worksheet Functions | |||
| Combining IF OR and AND functions | Excel Worksheet Functions | |||
| Combining SUMIF and SUBTOTAL functions | Excel Worksheet Functions | |||
Threaded Mode
