Hiding formulas
 

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


--
Donald
------------------------------------------------------------------------
Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171
View this thread: http://www.excelforum.com/showthread...hreadid=493310

Hiding formulas
 

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)

"Donald" wrote in
message ...

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


--
Donald
------------------------------------------------------------------------
Donald's Profile:
http://www.excelforum.com/member.php...o&userid=15171
View this thread: http://www.excelforum.com/showthread...hreadid=493310

Hiding formulas
 

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


--
Donald
------------------------------------------------------------------------
Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171
View this thread: http://www.excelforum.com/showthread...hreadid=493310

Hiding formulas
 

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

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

And so forth.

Donald wrote:

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

--
Donald
------------------------------------------------------------------------
Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171
View this thread: http://www.excelforum.com/showthread...hreadid=493310

--

Dave Peterson

Hiding formulas
 

Which cell do I add this too?


--
Donald
------------------------------------------------------------------------
Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171
View this thread: http://www.excelforum.com/showthread...hreadid=493310

Hiding formulas
 

All of your formula cells.



Donald wrote:

Which cell do I add this too?

--
Donald
------------------------------------------------------------------------
Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171
View this thread: http://www.excelforum.com/showthread...hreadid=493310

--

Dave Peterson