I don't want it to display # when there is no result

Originally Posted by Limelight

I am using very simple formulas and what not in my programme, yet there is a link to a sheet were I only want the results if there has been something entered. This is because this sheet are reports to be printed and a whole lot of #'s looks funny. If there are no numbers entered then I don't want a # displayed, I need it left blank. Please can someone help

Thanks

Amend your fomulas like this

=if(your_formula="","",your_formula)

Replace text "your_formula" with formulas you are currently using.