Empty cells that contain formulas

[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!

 

[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!

Make the formula something like:
=if(len(Calculations!C16)=0,"",Calculations!C16)

 

[Carl Witthoft]

Make the formula something like:
=if(len(Calculations!C16)=0,"",Calculations!C16)

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.