How do i hide a solution until data is entered

D

Dean

I have created a table to calculate set formulas but i have to add .5 to all
of my formulas and that is showing in the box. How do i hide that figure
until i put data into the original box before the formula is calculated
 
M

Michael M

Hi Dean
Maybe you could post a sample of what you are trying to do.
Otherwise try
1. Include the .5 in your formula so it is all calculated together.
2. Put the .5 in a remote cell and then add another formula
3. put the .5 in a cell and make the font the same colour as the background.

HTH
Michael
 
P

Peo Sjoblom

=IF(original_box="","",your formula+.5)

--
Regards,

Peo Sjoblom

Portland, Oregon
 
Top