static numbers vs formulas

M

mlk72

Hello,

I have what I am sure is a very basic question but I am clueless.

Can someone explain to me the difference between a static number vs
formula/calculation? Does it mean the number is constant?

How do I change a calculation into a static number?

Thanks for any help
 
F

Frank Kabel

Hi
a formula gets re-calculated if the refereced cells are changed. You
can convert a formula to a static value by copying the formula cell and
inserting it with 'Edit - Paste Special - Values'
 
Top