Currency

[Peter Downes]

Hi

I want to create an invoice template as shown below.

The calculation to determine the total is simple (=b3*b4).
The trick is to not display anything in the Total column unless there is a
value, but the formula must remain. This will tidy the document up nicely.

How can I do this?

Thanks | Peter

Item Qty Unit Cost Total
Test 2 R 4.50 R 9.00
R 0.00
R 0.00
R 0.00
R 0.00
R 0.00
R 0.00
R 0.00
R 0.00
R 0.00
R 0.00
R 0.00
R 0.00
R 0.00
Subtotal R 9.00
VAT (14%) R 1.26

Total R 10.26

 

[Ken Wright]

=IF(B3*B4<=0,"",B3*B4)

or

MAX(0,B3*B4) and format as accounting, in which case even a 0 will show as a
dash -

 

[Peter Atherton]

Peter

=if(b3=0,0,b3*b4) will show a zero. You can stop the
display of zeros from the Options dialog box.

Choose Tools, Options, ViewTab and make sure that the
Display Zeros check box is not clicked.

or =if(b3=0," ",b3*b4) will put a space into the formula
cell.

Regards
Peter