What is the command to replace a cell's formula with it's value?

Without regard to paste special and the F2/F9 approach, why would there not
be a function that returns the value of a cell for use in other formulas?

The only solution appears to be a script.

For example if you want to check for a value in a formula, or if you want to
cross multiple work sheets with a list controled index, or if you want to use
conditional statements based on the value derived by formula?

Not sure I follow.
Let A1 = 2 and B1 =3
So C1 with formula =A1+B1 will return 5
I can test the value in C1: in D1 enter =IF(C1=5,"it is five", "it is not
five")
But you could mean something else.
Care to expand your question with an example?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"sgeer" wrote in message
...

Without regard to paste special and the F2/F9 approach, why would there
not
be a function that returns the value of a cell for use in other formulas?

The only solution appears to be a script.

For example if you want to check for a value in a formula, or if you want
to
cross multiple work sheets with a list controled index, or if you want to
use
conditional statements based on the value derived by formula?