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

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

"Dean" wrote:

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

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"Dean" wrote in message
...
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