G Guest May 5, 2005 #1 How do I prepare a cell with a formula, but keep it blank until the information is added to activate the equation?
How do I prepare a cell with a formula, but keep it blank until the information is added to activate the equation?
M Max May 5, 2005 #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
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
G Guest May 5, 2005 #3 Thank you very much Max! Max said: 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 Click to expand...
Thank you very much Max! Max said: 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 Click to expand...
