Rounding numbers based on IF function

[EsorC]

Hey!

I am trying to round numbers.

Basically, if the actual number is 1 digit + decimal places, I want it to use this formula: =MROUND(A1,0.05).

If the actual number is 2 digits + decimal places, I want it to round down anything that xx.49 and under to the same integer, and anything that is xx.51 and over to the next whole integer.

I want these two things to be the same formula, is that possible?

Thanks!

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[EsorC]

Thanks! I edited.

[MrShorty]

Basically, if the actual number is 1 digit + decimal places,

Assuming A1 is always positive (always greater than 0), =IF(A1<10,...,...)

I want it to use this formula: =MROUND(A1,0.05).

=IF(A1<10,MROUND(A1,0.05),...)

I want it to round down anything that xx.49 and under to the same integer, and anything that is xx.51 and over to the next whole integer.

=IF(A1<10,MROUND(A1,0.05),MROUND(A1,1))

I notice that your example seems to follow a different logic from what you describe above. Your example shows that you want to round 1.45 up to 1.50 rather than to 1.45. You also show that you want to round 1.64 to 1.60 rather than 1.65. At the same time, you show that you want 5.25 to round to 5.25. There seems to be some inconsistency in your examples. If your examples are correct, we probably need a better explanation of the logic of when to round to x.x5 and when to round to x.x0.

[EsorC]

Thank you so much!

I just realized those inconsistencies myself, it was a mistake on my part.

Edit: I just uploaded the Correct version of my example.

[bebo021999]

Try:

=mround(a2,if(a2<10,0.05,1))

[bebo021999]

Raising question from #4 still remain, for me:

what is the general logic of:

1.45=>1.5
5.25=>5.25

[EsorC]

Raising question from #4 still remain, for me:

what is the general logic of:

1.45=>1.5
5.25=>5.25

A mistake on my part, it was supposed to be
1.45=>1.45
5.25=>5.25.

Same as
1.64=>1.65, not 1.64=>1.60.

[bebo021999]

So, does my solution in #6 work?

=MROUND(A2,IF(A2<10,0.05,1))