Using MROUND HELP!!

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

In creating a price list in Excel, I have taken a list
price, calculated our cost and our selling price. I would
like to round the result of the calculation for selling
price up to the closest 5¢. Can anyone help?

Thank you!
 
Andrew,

For rounding up to the nearest nickle.

=MROUND(A1+0.025,0.05)

Good Luck,
Mark Graesser
(e-mail address removed)

----- Andrew wrote: -----

In creating a price list in Excel, I have taken a list
price, calculated our cost and our selling price. I would
like to round the result of the calculation for selling
price up to the closest 5¢. Can anyone help?

Thank you!
 
If you have the Analysis Toolpackage installed use
=MROUND(A1,0.05)

Without you can use
=ROUND(A1*2,1)/2

HTH
Frank
 
Frank
Andrew is looking to round up. The second formula would then be

=ROUND(A1*2+0.049,1)/

I used .049 instead of .05, otherwise a value which is already an even nickel will go up to the next nickel. This formula will work for values down to one tenth of a cent

Regards
Mark Graesse

----- Frank Kabel wrote: ----

If you have the Analysis Toolpackage installed us
=MROUND(A1,0.05

Without you can us
=ROUND(A1*2,1)/

HT
Fran

Andrew wrote
 
In creating a price list in Excel, I have taken a list
price, calculated our cost and our selling price. I would
like to round the result of the calculation for selling
price up to the closest 5¢. Can anyone help?

Thank you!
Click to expand...

To Roound Up to the closest 5 cent:

=ROUNDUP(A7*20,0)/20

--ron
 
Back
Top