=ceiling(i62*d63,50)
or
=floor(i62*d63,50)

Take a look at excel's help for more info.


Lynne wrote:

I know how to round a cell, I know how to set up a function in a cell but I
am trying to round the result of the function that I have already set up in
the cell

=PRODUCT(I62,D63) - is the current cell function
I am taking that and the next step is multiplying that to get a
percentage.... .025 percent....that ends up equaling something like 1434 and
I need to get that cell to

ROUND up to the next 50 or round down 50....does this makes sense?....it is
driving me crazy your help is greatly appreciated!!!

--

Dave Peterson