Is there a way to make a result from an IF or SUM a constant?

[wvilliers]

Hi,

I want to use a macro or a simple formula, it doesn't matter which, and have
the result remain the same, even though week on week the cells in the formula
will change value.

This is because each week I will have a different column using the same
formula as the column before it but the result will be different each time
because the data in the formula will change each week. However I need the
results in each progressive week's column to remain the same.

Is there a way of doing this?
Thanks

 

[Bob Umlas, Excel MVP]

Maybe you can type the formula you want, but instead of pressing enter you
can press F9, entering just the result.
Bob Umlas