Empty cells that contain formulas

O

oldgustav

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hello, I have an invoice template set up in Excel that has 15 lines available for entering the details of the invoice. Each line, includes quantity, description, unit price and line total. The lines of information are 'looking at' another sheet in the same workbook where the 'working out' is done, so a simple, cell B20 = Calculations!C16. Is there a way for the unoccupied lines of the invoice template to keep their formulas, but to display an empty cell instead of '0'? I am setting this template up for a friend who is not at all Excel savvy. Many thanks!
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Hello, I have an invoice template set up in Excel that has 15 lines available
for entering the details of the invoice. Each line, includes quantity,
description, unit price and line total. The lines of information are 'looking
at' another sheet in the same workbook where the 'working out' is done, so a
simple, cell B20 = Calculations!C16. Is there a way for the unoccupied lines
of the invoice template to keep their formulas, but to display an empty cell
instead of '0'? I am setting this template up for a friend who is not at all
Excel savvy. Many thanks!
Click to expand...
Make the formula something like:
=if(len(Calculations!C16)=0,"",Calculations!C16)
 
C

Carl Witthoft

Bob Greenblatt said:
Make the formula something like:
=if(len(Calculations!C16)=0,"",Calculations!C16)
Click to expand...

Except that is not strictly empty. It will display as blank, but does
not behave (cf. threads on charting) as a completely blank cell would.
 
Top