| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Condition to Formula
I have to add to the following formula:
=IF(OR(C12={"None";""}),"",VLOOKUP(A12&"-"&F12&"-"&G12,INDIRECT(CHOOSE(MATCH(C12,{"Internal";"Exter nal"},0),"'Writing Charges'!D3:E60","'Writing Charges'!G3:H60")),2,0)*I12) the next part needs to be If B12="SM" than don't add anything If C12="NONE" than don't add anything If C12="Internal";"External" then VLOOKUP(A12&"-"&F12 than "'Proof Layout Charges'!c3:d31","'Proof Layout Charges'!c3:d31")),2,0)*I12 Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MORE THAN ONE CONDITION IN A FORMULA | Excel Worksheet Functions | |||
| Formula For If & Or Condition | Excel Discussion (Misc queries) | |||
| If formula and #N/A as a condition | Excel Discussion (Misc queries) | |||
| HELP? ...a second condition in one formula | Excel Worksheet Functions | |||
| Add condition to formula | Excel Worksheet Functions | |||
Threaded Mode
