Formula needed to hide “no data” text in cells

[excelteam777]

WS Attached

Hoping there is a quick fix for this. Basically when I have a formula in a range of cells
And the data is not present I see either a #N/A or #DIV/0! In the cell. I would like for the cell to appear blank when no data is present.

Please see ‘STATS’ T15 & U15

[JohnTopley]

See reply to your earlier post:

Returns blank if Error

=IFERROR(yourformula,"")

[vlady]

you have to use error handling one way is using the iferror

=iferror(your exisitng formula here,"") -the "" means blank


Edit: oopsss.... I'm late

[excelteam777]

Please see attached WS
'SALES' J22:J507 shows the issue I am having.

Those range of cells are date format. When no data is entered into the connecting cell, instead of it being blank it returns as 01/00/00
which in turn messes up all my calculations throughout the page as I use dates for certain calculations.

How can we have it come back truly blank so it does not mess up the calculations?

Thanks

[JohnTopley]

Try

=IF(LEADS!L6="","",LEADS!L6)

[excelteam777]

Works thanks