=Round Formula Problem

[sstrachan]

I have a formula that works great to perform a calculation. Some of the values in my table are zero, so i have a ISERROR formula as well to supress the error when dividing by zero. I am trying to use my current formula and now Round the result to the nearest 2 decimal places, and still supress the Errors that appear when dividing by zero. Is this possible?
The original formula I want to modify is:
=IF(ISERROR(X2/$F2)," ",(X2/$F2))

I want to use the ROUND formula with this formula so that the result shows 2 decimal points. Can anyone assist me on modifying my above formula?

 

[VoG]

Try

=IF(ISERROR(X2/$F2)," ",ROUND((X2/$F2),2))

 

[sstrachan]

Thank You for the quick response. It worked perfectly. I appreciate your assistance.

 

[Scott Huish]

BTW, you don't need ISERROR to avoid #DIV/0!, you just need to check if you are dividing by 0 or not. You also should use "" (empty string) instead of " "(space) to return blank:

=IF($F2,ROUND(X2/$F2,2),"")

 

[sstrachan]

Thanks for the advice. I appreciate the feedback.