Hiding formulas

D

Donald

How does one hide formulas in cell that are not yet being used, anothe
words if i copy a formula down several rows, but only enter info eac
day when i go to print the report for that day it shows all of the inf
plus the next formulas
 
B

Bob Phillips

Check if the cell being referred to has data. For example

=IF(A10="","",A10*5)

when A10 is empty, you will see nothing.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

Donald

Thanks for the info, but here is a stupid question when I put this
formula in the unused data cell, It still shows the formulas, example:
a-1 and b-1 are is where the data will be entered so a1+b1 should be
empty and the formulas start in c1.

a-1 b-1 c-1 d-1 e-1
a1+b1 b1-a1 b1/a1

I want to hide the results of the formulas until data is put into a-1
b-1
 
D

Dave Peterson

You could check for a count of numbers in the range first:

=if(count(a1:b1)<2,"",a1+b1)

And so forth.
 
Top