static numbers vs formulas

[mlk72]

Hi Frank,

Thanks for your help. My only question is why would I want to do this
I could just as easily enter in my formula to get my answer - the
format the answer to a number so it wouldnt change from month t
month?

I guess I just dont see the benefit of this functionality.

What am I missing?

Thanks,
Monic

 

[Myrna Larson]

Whether your formula result "changes from month to month" depends on the
formula. If it uses the current date, it will change when the date changes.

 

[Gord Dibben]

Monica

Why would you want to do this?

Assume you have 4 in A1 and 5 in B1

In C1 enter =A1 + B1 to return 9 in C1

If either or both A1 and C1 change, C1 will change, so the 9 is not "static".

Formatting C1 as a number will not remove the formula. Formats just change
how things look, it does change the underlying value or formula.

The benefit of Frank's copy>paste special>values is to remove the =A1 + B1
formula so C1 cannot change if A1 and B1 values are altered.

Gord Dibben Excel MVP