| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add Condition to Formula
Create another column, say at A12, that translates B12 into
the text of the worksheet name: =IF(B12="SM","WC",IF(B12="CD","PLC","")) WC=WritingCharges PLC=ProofLayoutCharges In your formula, replace "'WritingCharges'!xx:yy" with A12&"!xx:yy" |
| 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
