Round Formula

matthew · Jul 17, 2003

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 · Jul 17, 2003

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

Dan E · Jul 17, 2003

=CEILING(A1*10,50)

Dan E

Paul Corrado · Jul 17, 2003

Matthew,

Try

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

PC

Stephen Dunn · Jul 17, 2003

=ROUND(A1/5,0)*50

I think...

Round Formula

matthew

TGB

Dan E

Paul Corrado

Stephen Dunn