how can i "=MROUND(J33,50)"
 

i'm trying to round cell j33 to a multiple of 50 or 100 whatever. but j33 is
the outcome of another ormula so i will never know what it will be.

how can i "=MROUND(J33,50)"
 

I assume you mean there is already a formula in J33, in which case
=MROUND(formula,50) should do it.

eg if the formula in J33 is =SUM(J25:J32) then your new formula would be
=MROUND(=SUM(J25:J32),50)

--
Ian
--
"rich" wrote in message
...
i'm trying to round cell j33 to a multiple of 50 or 100 whatever. but j33
is
the outcome of another ormula so i will never know what it will be.

how can i "=MROUND(J33,50)"
 

What 'rules' do you have in mind for rounding?
When will you want 50, when will you want 100?
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rich" wrote in message
...
i'm trying to round cell j33 to a multiple of 50 or 100 whatever. but j33
is
the outcome of another ormula so i will never know what it will be.

how can i "=MROUND(J33,50)"
 

=MROUND(the existing formula,50)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"rich" wrote in message
...
i'm trying to round cell j33 to a multiple of 50 or 100 whatever. but j33
is
the outcome of another ormula so i will never know what it will be.