LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Darryl
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Rows/Columns for Copying Formulas SamDev Excel Discussion (Misc queries) 0 June 24th 05 04:13 AM
Percentages Darryl Charts and Charting in Excel 2 May 21st 05 04:31 PM
How to set a formula to count the product appear how manytime AMY Excel Worksheet Functions 3 March 21st 05 09:49 AM
Which Function(s) do I use? LB Excel Worksheet Functions 3 January 6th 05 02:53 AM
Which function(s)? LB Excel Worksheet Functions 3 January 5th 05 06:19 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"