Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if/then, OR formulas
Hi! Any help is greatly appreciated.
I have a multi-row, multi-column worksheet. In column J I have a list of numbers. In column O I have a different set of numbers. For each row, there is a unique value in column J and column O. 1) For each row, in column P, I would like the numeric amount from column N to appear IF 1) the number in column J equals 07, 08, 52, 60, 70, 71, or 80 OR 2) if the number in column O equals 14, if neither of these are true, then I would like a 0 to appear. Any ideas or suggestions? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple worksheet formulas | Excel Discussion (Misc queries) | |||
Sort multiple columns with multiple formulas without returning #R | Excel Worksheet Functions | |||
lookup formulas to obtain multiple results | Excel Worksheet Functions | |||
Changing multiple formulas at one time | Excel Worksheet Functions | |||
Formulas for Multiple sheets in a workbook | Excel Discussion (Misc queries) |