| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multi functions
Going nuts trying to make this equation fit all possible situations - I'd
like an equation to put in G that would look at mutliple IFs/ANDs: IF B="in house" and C=Jack then E x .05 IF B="in house" and C=Jill then E x .05 IF B="in house" and C=(no name) then E x .06 IF B=anything other than "in house" and C=Jack then E x .01 IF B= anything other than "in house" and C=Jill then E x .01 IF B=anything other than "in house" and C=no name then E x .02 Is this possible to do in one equation? All suggestions welcome. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
| PASTE DOWN FUNCTIONS | Excel Worksheet Functions | |||
| 3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
| # of Functions per cell | Excel Worksheet Functions | |||
| Where can I see VBA code for financial functions? | Excel Worksheet Functions | |||
Threaded Mode
