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 <at>yahoo<dot>com
----
"JP" <JP@discussions.microsoft.com> wrote in message
news:F6AC149B-0D78-459D-8B49-6180A1608ED7@microsoft.com...
> 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 <at>yahoo<dot>com
> ----
> "JP" <JP@discussions.microsoft.com> wrote in message
> news:F6AC149B-0D78-459D-8B49-6180A1608ED7@microsoft.com...
> > 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 <at>yahoo<dot>com
----
"JP" <JP@discussions.microsoft.com> wrote in message
news:6388B022-4602-422F-ACF0-A2B30EB10112@microsoft.com...
> Thank you very much Max!