Displaying Product value only when it is greater than $0.00
I need to know the formula for displaying the dollar value of a PRODUCT only
when the value is greater than $0.00. I am making an Invoice sheet and do want zero values to appear when there is no value above zero dollars. Cells are setup as currency. The value even though zero would be calculated by a SUM at the bottom of the column. |
Hi, Darryl. Consider conditional formatting to change the font to white
dependent on the value of the Total cell. http://www.officearticles.com/excel/...ft_ excel.htm ************ Anne Troy www.OfficeArticles.com "Darryl" wrote in message ... I need to know the formula for displaying the dollar value of a PRODUCT only when the value is greater than $0.00. I am making an Invoice sheet and do want zero values to appear when there is no value above zero dollars. Cells are setup as currency. The value even though zero would be calculated by a SUM at the bottom of the column. |
Either set zero display off (ToolsOptionsView, uncheck 'Zero Values')
Or, use a custom format of say [<0]"";[=0]"";General -- HTH RP (remove nothere from the email address if mailing direct) "Anne Troy" wrote in message ... Hi, Darryl. Consider conditional formatting to change the font to white dependent on the value of the Total cell. http://www.officearticles.com/excel/...ft_ excel.htm ************ Anne Troy www.OfficeArticles.com "Darryl" wrote in message ... I need to know the formula for displaying the dollar value of a PRODUCT only when the value is greater than $0.00. I am making an Invoice sheet and do want zero values to appear when there is no value above zero dollars. Cells are setup as currency. The value even though zero would be calculated by a SUM at the bottom of the column. |
All times are GMT +1. The time now is 03:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com