Using MROUND HELP!!

[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!

 

[Mark Graesser]

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!

 

[Frank Kabel]

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

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

HTH
Frank

 

[Mark Graesser]

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

 

[Ron Rosenfeld]

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!

To Roound Up to the closest 5 cent:

=ROUNDUP(A7*20,0)/20

--ron

 

[Frank Kabel]

Hi Mark

missed that word 'up'. Have to read more carefully

Greetings
Frank