static numbers vs formulas

  • Thread starter Thread starter mlk72
  • Start date Start date
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
 
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'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
Formula vs. Constant 24
formula question 2
Need a formula for a descimal integer into a whole number 1
Suppressing #VALUE! in calculated field in Pivot Tbl 1
Date Value Error 6
Countif Formula 1
NETWORKDAYS 3

Back
Top