View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default How do i hide a solution until data is entered

=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