I have a template used for generating invoices, and in the interest of making it work a little faster I was looking for ways to automate/speed up the process. The template already (using mailmerge etc) pre-populates the date, invoice number and customer information. I use drop downs for payment and shipping methods.



I use a table only for the part of the invoice for the line items being sold with 4 columns- Quantity, Description, Price and Extended price. First row is headings.

So for each line I want the item total (in the first line it's d2) to be a blank space, and only show a result if there is a quantity (a2), which then will extend out the total by multiplying it with the price (c2).

Here is the formula I entered in d2 (using CTRL-F9 to create the nested formula)

{ if a2 > 0 { a2*c2 } " " }

Works great for calculating the item extensions if there is an item on that line. Unfortunately if a2 is blank the result in d2 is 0 (I want it to be blank).

What am I doing wrong?

Thanks,

Mark

Cross-posted (and answered) at: http://windowssecrets.com/forums/sho...get-it-to-work
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

As for:
I'd say, not paying attention to the tutorial you were directed to at the other forum.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]