Displaying Product value only when it is greater than $0.00

D

Darryl

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.
 
B

Bob Phillips

Either set zero display off (Tools>Options>View, uncheck 'Zero Values')

Or, use a custom format of say [<0]"";[=0]"";General

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A SUM FUNCTION (EXCEL) RETURNS A ZERO VALUE BUT DISPLAY IN (0.00), 2
Combining Text based on Values 8
Greater than, less than, AS WELL AS value=0 5
Adding cells until they are greater than a lookup cell and returning a value 1
Conditionally format: Only if unique identifier and exceeds % of previous record 0
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
Formatting Cell that displays sum from other worksheets 3
Show value from one cell in another cell if today falls between a date range 5

Top