software

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

quot;Deanquot; wrote:

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

=IF(original_box=quot;quot;,quot;quot;,your formula .5)

--
Regards,

Peo Sjoblom

Portland, Oregon

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