Should be easy - Value and Formula
 

I am having a brain dump. I know this should be easy but I can't remember. I
have a Cell (let's say A1) in it has a formula that pulls information from
another cell and multiplies it by a third cell then etc. etc. etc.) What I
want to do it make cell B1 have just the value of the formula from A1.
Whatever the value woudl be then in B1 it would have just that, no formula
string.

Can anyone remind me? I thought it was =VALUE(A1) but not positive.

Should be easy - Value and Formula
 

You'll always have a formula in B1, given your scenario. Just enter =A1.

Dave
--
Brevity is the soul of wit.


"David" wrote:

I am having a brain dump. I know this should be easy but I can't remember. I
have a Cell (let's say A1) in it has a formula that pulls information from
another cell and multiplies it by a third cell then etc. etc. etc.) What I
want to do it make cell B1 have just the value of the formula from A1.
Whatever the value woudl be then in B1 it would have just that, no formula
string.

Can anyone remind me? I thought it was =VALUE(A1) but not positive.

Should be easy - Value and Formula
 

Another option:

=if(a1="","",a1)

If A1 is empty, this will make B1 look empty.

David wrote:

I am having a brain dump. I know this should be easy but I can't remember. I
have a Cell (let's say A1) in it has a formula that pulls information from
another cell and multiplies it by a third cell then etc. etc. etc.) What I
want to do it make cell B1 have just the value of the formula from A1.
Whatever the value woudl be then in B1 it would have just that, no formula
string.

Can anyone remind me? I thought it was =VALUE(A1) but not positive.

--

Dave Peterson