Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Empty Cell ( blank Cell ) | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Go to first blank cell | Excel Worksheet Functions | |||
Ghost Blank Cell References | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |