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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wanda M - 25 Sep 2007 13:02 GMT

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

Reply to this Message

CLR - 25 Sep 2007 13:12 GMT

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

or

=MROUND(M4*2.1,5)

Vaya con Dios,
Chuck, CABGx3

> 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

Reply to this Message

Wanda M - 25 Sep 2007 13:38 GMT

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

> =MROUND((M4*1.1)+M4,5)
>
[quoted text clipped - 10 lines]
> >
> > Tx

Reply to this Message

CLR - 25 Sep 2007 13:40 GMT

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

Vaya con Dios,
Chuck, CABGx3

> Thank you CLR! Works like a charm and you saved me hours of research!
>
[quoted text clipped - 12 lines]
> > >
> > > Tx

Reply to this Message

David Biddulph - 25 Sep 2007 17:43 GMT

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)

Signature

David Biddulph

> =MROUND((M4*1.1)+M4,5)
>
[quoted text clipped - 12 lines]
>>
>> Tx

Reply to this Message

CLR - 25 Sep 2007 17:56 GMT

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

Vaya con Dios,
Chuck, CABGx3

> 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
[quoted text clipped - 15 lines]
> >>
> >> Tx

Reply to this Message