Rounding to

[Steven]

I have a column of numbers, all multiples of 10, starting at 100 and going
up into the thousands. I want to round them to the nearest 50, so 140 would
become 150 and so would 160. How do I do that?

TIA

Steven

I plan to live forever.....or die trying!

 

[Bob Phillips]

=ROUND(A1/50,0)*50

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Steven]

Ok, this is a little more complicated than just rounding. Column B has a
figure which is multiplied by column D to get the amount in column F. So
right now, it looks like =B3*D3 and what I need it to do is round that
figure to the nearest 50. So it would be something like
=(B3*D3)=Round(F3,50))? Sorry I did not get this on sooner.

 

[Bob Phillips]

=ROUND(B3*D3/50,0)*50


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Steven]

That is exactly what I needed, thank you very much.

Steven

 

[bplumhoff]

Hello Steven,

Another solution:
=ROUND(A1*2,-2)/2

HTH,
Bernd