Hide Contents of Calculated Cell
 

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.

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.

Beautiful - thanks, Trevor.

Prior Sayin


"Trevor Shuttleworth" wrote in message
...
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.

You're welcome

Regards

Trevor


"Prior Sayin" wrote in message
...
Beautiful - thanks, Trevor.

Prior Sayin


"Trevor Shuttleworth" wrote in message
...
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.