Trying to insert a ROUND function into a formula

[Rudboy66]

Greetings, please excuse my rudimentary Excel skills . . . hopefully someone can help me out based on my explanation.

I have two cells in a working spreadsheet that work perfectly, until I try to round the result to "2" decimal places. The way they are currently setup is that when A13 has nothing in it, then M13 also displays a blank cell....great and it works.

However, when I try to round the result in M13 I get an error message #VALUE! when A13 is blank.

The current formula in M13 is:

=IF(A13="","",(J13+K13+L13)*0.0075)

So I guess my question is, how do I round the result of the above formula to 2 decimal places, and still get M13 to show a blank cell when A13 is blank? Again, please excuse the cryptic and convoluted explanation.

Any help would be greatly, greatly appreciated!

 

[Rudboy66]

SUCCESS!

I don't think you understand how much this helps me, I really appreciate it! These last two formulas were the only thing keeping from finishing this worksheet, and, the only thing keeping me from getting to bidding (i.e. making a living).

Now that you've helped me with these formulas I can get too it. I guess this proves that someone with just a bit of knowledge can be dangerous, unless they have a forum of experts to help troubleshoot problems!

Cheers and thanks again!