Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I substitute a conditional parameter in every formula on page
I would like to have a series of worksheets where each recognizes a specific,
unique conditional parameter in part of a formula, without having to change each pages' individual cells' formulas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I substitute a conditional parameter in every formula on page
Allocate a cell, say A1, on each sheet to hold the parameter. The formulas
can be the same, but each sheet can hold a different value in A1 -- Gary''s Student - gsnu200761 "Paulyfudd" wrote: I would like to have a series of worksheets where each recognizes a specific, unique conditional parameter in part of a formula, without having to change each pages' individual cells' formulas |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I substitute a conditional parameter in every formula on p
Thanks
I got it linked to a time stamp formula on a protected page, now Cheers "Gary''s Student" wrote: Allocate a cell, say A1, on each sheet to hold the parameter. The formulas can be the same, but each sheet can hold a different value in A1 -- Gary''s Student - gsnu200761 "Paulyfudd" wrote: I would like to have a series of worksheets where each recognizes a specific, unique conditional parameter in part of a formula, without having to change each pages' individual cells' formulas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I repeatedly substitute a value in a formula | Excel Worksheet Functions | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
Concatonate and Substitute show the formula rather than the result | Excel Worksheet Functions | |||
Nesting the SUBSTITUTE formula | Excel Worksheet Functions | |||
Substitute Formula | Excel Worksheet Functions |