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!

 

[jmthompson]

=if(a13="","",round(((j13+k13+l13)*0.0075),2))

 

[Scott Huish]

=if(a13="","",round(sum(j13:l13)*0.0075,2))

 

[Rudboy66]

WOW...that was fast response!

J13 Contains this formula: =IF(OR(A13=""),"",H13+I13)

K13 is just a number I enter in this case $1,500.00

L13 is also an entered value in this case $1,440.00

 

[Rudboy66]

It looks like =if(a13="","",round(((j13+k13+l13)*0.0075),2)) worked!

I have one other cell that is giving me fits with a similar problem, let me see if I can post that and get it solved to. And btw....thank you VERY much for the fast and accurate responses!

 

[jmthompson]

Thanks for the feedback

 

[Rudboy66]

Ok, I tried to look at your formula and do cell O13 by myself but so far no luck. The parentheses give me fits.

So, I'm looking for the exact same result (2 decimal points) in O13. Blank if A13 is blank otherwise this is the current formula in O13.

=IF(A13="","",(N13/F13))

Again, thanks for any help.

 

[jmthompson]

=IF(A13="","",ROUND((N13/F13),2))


But if F13 is blank, then you will get a DIV/0! error

 

[Rudboy66]

=IF(A13="","",ROUND((N13/F13),2))


But if F13 is blank, then you will get a DIV/0! error

And of course F13 will be blank. Any way to fix this?

 

[jmthompson]

=if(or(a13="",f13=""),"",round((n13/f13),2))