| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two IF's in one formula?
Hey, if I have a table of data and want to report the figure in a given cell
IF one text arrangement appears in one range of cells, AND another text arrangement appears in another range of cells - how do we do this? Eg - i'd want a formula covering ranges A, B, C to pull a result from C into Z when Cat appears in A and Dog appears in B only..? A B C.......Z - Cat & Dog Cat Dog 21 21 Cat Pig 54 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nine IF's in a formula | Excel Discussion (Misc queries) | |||
| Too many 'if's! | Excel Discussion (Misc queries) | |||
| How many 'if's'? | Excel Discussion (Misc queries) | |||
| Formula with multiple IF'S | Excel Discussion (Misc queries) | |||
| How many if's? | Excel Discussion (Misc queries) | |||
Threaded Mode
