Help with the Round function

[microhunt]

Hi, Everyone, I am using the following formula with the round function, which works fine.

=ROUND(SUM(M4/52*4),2)

However, I find it difficult to get the round function working within the formula below in the same way. =Round,2

=IF(M4>0,IF(V4=FALSE,SUM(B4:D4)-H4,+N4-H4),"")

I really appreciate any help you can provide.

 

[Joe4]

Try this:

=IF(M4>0,IF(V4=FALSE,ROUND(SUM(B4:D4)-H4,2),ROUND(N4-H4,2)),"")

By the way, the SUM in your first formula serves no purpose since you are only dealing with one cell. You can simply use:

=ROUND(M4/52*4,2)

 

[Jeffrey Mahoney]

How about this?
=IF(M4>0,ROUND(IF(V4=FALSE,SUM(B4:D4)-H4,+N4-H4),2),"")

 

[microhunt]

Try this:

=IF(M4>0,IF(V4=FALSE,ROUND(SUM(B4:D4)-H4,2),ROUND(N4-H4,2)),"")

By the way, the SUM in your first formula serves no purpose since you are only dealing with one cell. You can simply use:

=ROUND(M4/52*4,2)

Thank you. The first formula use to deal with 2 other cells, and you are quite right, no purpose is served now. I have changed it and thanks very much.

 

[Joe4]

How about this?
=IF(M4>0,ROUND(IF(V4=FALSE,SUM(B4:D4)-H4,+N4-H4),2),"")

Yes, that is even more efficient. I originally thought that the "" pertained to the inner IF, and not the outer one.
So you only do need to add one ROUND function there, not two.

 

[Joe4]

microhunt,

Please Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you. I chose Jeffrey's solution, as it uses the same concept as fine, but is more concise/efficient.

 

[Scott Huish]

You could shorten that a little bit by just putting the TRUE portion for V4 first instead of FALSE

=IF(M4>0,ROUND(IF(V4,N4-H4,SUM(B4:D4)-H4),2),"")

 

[microhunt]

Yes, that is even more efficient. I originally thought that the "" pertained to the inner IF, and not the outer one.
So you only do need to add one ROUND function there, not two.

Thank You