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.