You haven't made it clear where percentage comes into it. If you have just
got straight numbers then CLR's =MROUND(140*0.55,5) will be fine, but if one
of the numbers is a percentage & you've got an answer which is a percentage
then you'd need
=MROUND(140%*0.55,5%) or =MROUND(140%*0.55,0.05) [formatting the answer as
a percentage if you want it that way].

If you get a #NAME! response from MROUND, look up MROUND in Excel help.
--
David Biddulph

"Jeremy" wrote in message
...
I am looking for the formula that allows me to take a cell with the value
of
140 for example. In the next cell I want to multiply the previous cell by
.55. I would then like to round that cell to the nearest 5. So I would
like
to have 77 automatically converted to 75. I think the formula involves
=MROUND but I'm not sure how to use it while doing the percentage
calculations and rounding at the same time.

Hopefully this makes sense to someone. Tried to put the question as
simply
as possible.