# I need a %age increase formula that rounds up to the nearest \$10

1. ## I need a %age increase formula that rounds up to the nearest \$10

I need to increase some prices by 4.5% and want them to round up/down to the
nearest \$10. For example: \$2750 * 4.5% = \$2873.75. I know how to knock out
the decimal point, but how can I make the formula round the price up/down to
the nearest \$10, in this case, \$2870.

Thanks

2. ## Re: I need a %age increase formula that rounds up to the nearest \$10

=MROUND(A1*(1+4.5%),10)

MROUND is an Analysis Toolpak function. If it is not available:

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Chopper_Haynes" <Chopper_Haynes@discussions.microsoft.com> wrote in message
news:E5509E0A-EA79-40FE-BAB1-072F264F7633@microsoft.com...
>I need to increase some prices by 4.5% and want them to round up/down to
>the
> nearest \$10. For example: \$2750 * 4.5% = \$2873.75. I know how to knock
> out
> the decimal point, but how can I make the formula round the price up/down
> to
> the nearest \$10, in this case, \$2870.
>
> Thanks

3. ## Re: I need a %age increase formula that rounds up to the nearest \$10

MRound will round up or down. It appears that they want to round up
only. I'd suggest:
=ceiling(A1*(1+4.5%),10)

Ceiling rounds up to the nearest interval. There is a floor function
that does the same thing only rounds down.

Melinda

4. ## Re: I need a %age increase formula that rounds up to the nearest \$10

The OP wrote "round up/down"

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Melinda" <melinda.chase@gmail.com> wrote in message
> MRound will round up or down. It appears that they want to round up
> only. I'd suggest:
> =ceiling(A1*(1+4.5%),10)
>
> Ceiling rounds up to the nearest interval. There is a floor function
> that does the same thing only rounds down.
>
> Melinda
>

5. ## Re: I need a %age increase formula that rounds up to the nearest \$10

Ahh...yes, I see that now. Stupid Google groups not having the
what the OP was looking for.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1