Prior

=IF(Quantity=0,"",Quantity*Unit Price)

Regards

Trevor


"Prior Sayin" wrote in message
...
Hi:

I have 4 columns:

Quantity Description Unit Price Extension

My Extension value is =(Quantity*Unit Price)

This works fine, but it enters $0.00 when no Quantity is entered. As I
list all Descriptions, only quantity gets entered. I need to suppress the
Extension value so it is blank if Quantity is blank.

Thank you so very much,

Prior.