Keeping the cell blank...
 

How do I prepare a cell with a formula, but keep it blank until the
information is added to activate the equation?

One way to make it appear blank ..

Instead of in say, B1: =A1*5
Put it as: =IF(A1="","",A1*5)

The " =IF(A1="","", ... " construct will provide the desired "blank" look
in B1 until a number is input in A1
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"JP" wrote in message
...
How do I prepare a cell with a formula, but keep it blank until the
information is added to activate the equation?

Thank you very much Max!

"Max" wrote:

One way to make it appear blank ..

Instead of in say, B1: =A1*5
Put it as: =IF(A1="","",A1*5)

The " =IF(A1="","", ... " construct will provide the desired "blank" look
in B1 until a number is input in A1
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"JP" wrote in message
...
How do I prepare a cell with a formula, but keep it blank until the
information is added to activate the equation?

You're welcome !
Thanks for the feedback
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"JP" wrote in message
...
Thank you very much Max!