Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing cell formulas
I wish to change the formula in a group of cells based upon a conditional.
For example if cell A1 is set to X then the formula in cells B2,B3 may be something. If I change cell A1 to Y then new formula's appear in cells B2, B3. If this posisble with macros. I have thought of if statements. Is this the only way |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing cell formulas
Hi,
you don't need a macro in cell B2 you can enter =if($A$1="X",your first formula,if($A$1="Y",your second formula,"")) in the case thar cell a1 is different from X or Y it will leave it blank if this helps please click yes, thanks "JulianP" wrote: I wish to change the formula in a group of cells based upon a conditional. For example if cell A1 is set to X then the formula in cells B2,B3 may be something. If I change cell A1 to Y then new formula's appear in cells B2, B3. If this posisble with macros. I have thought of if statements. Is this the only way |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying formulas and changing cell references | Excel Discussion (Misc queries) | |||
changing cell background colors with formulas | Excel Worksheet Functions | |||
Conditional Formulas for Changing Cell Color | Excel Worksheet Functions | |||
Changing Multiple Cell Formulas | Excel Discussion (Misc queries) | |||
Changing Cell References in Formulas | Excel Worksheet Functions |