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

W

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
 
D

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)
 
Top