Hiding the error codes reflected in cells

[Saky]

Friends,

I need to hide the error codes in the cells.

When i write formulas in the cell C for ex:=ROUND(SUM(A1+B18),0) and if i didnt enter any values in col A and B then col C is showing a error like #DIV/0!...

Is there anyway to hide it?

Thanks
Saky

[Marcol]

How does adding two values give you a #DIV/0 error?

What is your real problem?

[Saky]

Apologies, Marcol...I have mentioned the wrong formula in the thread.

Really sorry... The correct formula is ROUND((((O4/T4)/3600)/9),0). When i dont enter any values in O4 and T4 then the cell in which i have written this formula shows the error as #DIV/0!...I just want to hide this error.

Is there any option to do it.

[Marcol]

If you don't want to show the error under any conditions

Please Login or Register  to view this content.

If you want to only surpress the error when there are blank cells, but otherwise show it

Please Login or Register  to view this content.

Hope this helps

[Saky]

Brilliant!!!!! Thank you so much Marcol!!!!! Have a good day!!