invoice displays 0s when blank
I created an invoice. I have used the cells A through G.
Where A is the description of items and G is the Total sale. My problem is when
A is blank G displays $0.00 for total. How can I get G to be blank when A is
blank? Some other cells in between display 0 as well. I am currently using Microsoft
excel 2003.
Thank you
Software/Hardware used:
ASKED:
March 10, 2012 8:42 PM
UPDATED:
March 12, 2012 1:36 PM
Answer Wiki:
I assume that the column G is calculating something like the quantitiy times the unit price. If, instead of just putting in that equation, use something like =IF(B2>0,B2*C2,"").
If there is a positive quantity in filed B2, then G2 would have the product, but if the quantity field does not ahve a positive number in it, G2 would be vlank.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
