Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use the contents of a cell to satisfy the result_vector arg. | Excel Worksheet Functions | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |