Excel: Round formula up in $5. increments =+(M4*1.1)+M4

[Wanda M]

I have formulas that I want to round up to the nearest $5.00 My formula is
=+(M4*1.1)+M4. I have tried =mround, but I am doing something wrong.
Do I need to freeze part of the formula? Please help!

Tx

 

[CLR]

=MROUND((M4*1.1)+M4,5)

or

=MROUND(M4*2.1,5)

Vaya con Dios,
Chuck, CABGx3

 

[Wanda M]

Thank you CLR! Works like a charm and you saved me hours of research!

 

[CLR]

Happy to help, and thanks for the feedback............

Vaya con Dios,
Chuck, CABGx3

 

[David Biddulph]

That'll round to the nearest, but if the OP wanted us to answer the part of
the sentence that said she wanted to round *UP*, then it would be
=CEILING(M4*2.1,5)

 

[CLR]

Good catch David...........

Vaya con Dios,
Chuck, CABGx3