Rounding to

  • Thread starter Thread starter Steven
  • Start date Start date
S

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!
 
=ROUND(A1/50,0)*50

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
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.
 
=ROUND(B3*D3/50,0)*50


--

HTH

Bob Phillips

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