Cell Rounding Formula

So here is my problem. If I have data in cell A1, I would like cell B1 to round the data in A1. Here is my formula =ROUND(A1,2).

Now, if there is no data in A1 I get the #Value! error message. Is there a formula where the value error won't display?


Scratching my head.

Excel 2013

Same situation for an averaging formula. The cell also displays the value error. Here is my formula =L37/30

IFERROR is available in 2013 and will also work for your second formula.

6StringJazzer

Thank you. Those worked great.