ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I substitute a conditional parameter in every formula on page (https://www.excelbanter.com/excel-worksheet-functions/170474-can-i-substitute-conditional-parameter-every-formula-page.html)

Paulyfudd

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


Gary''s Student

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


Paulyfudd

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



All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com