How do I create a formula for calculating multiple invoice type items

**MGMRAM** · 07-09-2008, 11:09 PM

I cannot figure the formula that will allow me to sell products without the length and width in the line. I need to sell bulk products without dimensional sizes.

I do not want zeros to show on the invoice unless inputted.

This is the formual in the total column:

=IF(SUM(V8)>0,SUM((R8*T8)*V8)-Z8,"")

Please Help

**shg** · 07-09-2008, 11:30 PM

Please read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.

Think Google.

**ratcat** · 07-10-2008, 10:58 AM

G'day

When you have formula looking at a cell with other formula, in my experience the formula must return a value. The quotation mark ("") to represent blank does not work.

So I've told the formula to return a value of zero. Because you do not want the value of zero showing I have apply a 'Conditional Formatting' to the required cells. 'Format only cells that contain' rule and formatted the font white.

Please PM a Forum Mod to change the thread title. Thanks.

Post back or PM if more questions needed to be answered.

Hope this help