If you need to know the syntax of the ROUND function (or any other function
in Excel except for DATEDIF), look it up in Excel help.
--
David Biddulph

"havenlad" wrote in message
...
Indeed it does - well corrected.

What does the comma after the 5 at the end do?

"David Biddulph" wrote:

Does that INT formula round to the nearest? I thought that it would
round
down?

Perhaps instead you might want to try =5*ROUND(A1/5,0) ?

[Subject to my previous question as to where percentages come into the
question, so perhaps =5%*ROUND(A1/5%,0) ]
--
David Biddulph

"havenlad" wrote in message
...
=5*(INT(A1/5))

"Jeremy" wrote:

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.