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