Make a Formula Show Blank if '0' Value

[drsadistic]

I need this formula:

Please Login or Register  to view this content.

To show a blank instead of a "0.00" if the value is "0.00". Can anyone help?

[LokeshKumar]

it is always better to upload the workbook so other understand better and reply fast...

[mcmahobt]

Try:

Please Login or Register  to view this content.

[drsadistic]

I'm not entirely sure how uploading my workbook would help this particular situation. K17 is a today's date, F4:F374 is a range of sales data and B4:B374 is a range of dates from the beginning of the year to current. F and B are located on a sheet called "2015"... I'm sure you don't need an explanation on that sheets meaning. The formula I've pasted looks to the current date on K17, searches the range of dates on B and displays that dates value found in F.

[drsadistic]

That did the trick. Thank you for your help.

[Trebor76]

Hi there,

As far as I know you have two options:

1. Untick the Show a zero in cells that have zero value option in the Display Options for the Worksheet heading from the Excel Options > Advanced section of the workbook, or
2. Try this formula:
=IF(SUMIFS('2015'!F4:F374,'2015'!B4:B374,"="&K17)=0,"",SUMIFS('2015'!F4:F374,'2015'!B4:B374,"="&K17))

If the sheet is full of numbers the first option is probably the preferred (in my humble opinion) as the second mixes text with numerical data.

HTH

Robert