Round Formula

[matthew]

How can I type in Column A 224 then in Column B have it
return 2,250. As you see the number was multipied by 10
and then rounded to the nearest 50.

Thanks for your help

 

[TGB]

=CEILING((A??*10),50)

 

[Dan E]

=CEILING(A1*10,50)

Dan E

 

[Paul Corrado]

Matthew,

Try

=ROUND(A1*2,-1)*5

PC

 

[Stephen Dunn]

=ROUND(A1/5,0)*50

I think...