Rounding a formula to nearest 100 within a cell

I am trying to round $15,841 to read $15,800. The formula within this cell is "=L63*0.95". I understand the "Round" feature but not clear how to incorporate it within this cell.

Thanks.

pjfoster,

Something like this?
=ROUND(L63*0.95/100,0)*100

Alternatively,
=ROUND(L63*0.0095,0)*100

=ROUND(L63*0.95,-2)


Regards, TMS

Cant you just use

=INT((L63+50)/100)*100

delete the 0 in 0.95

makes it .95 only

I don't think that's the problem, Vlady....

There are multiple lines in that formula [select cell and press F2 to see that].

Try deleting the cell contents with Delete key then re-enter TMS' formula

ok..
not really the issue..

the cell you are typing is saving the previous typed formulas don't know why.. if you evaluTE THE FORMULA
THERE ARE ATLEAST 7 COPIES OF THE ROUND FORMULA..

i tried to delete the cell with the formula and reenter the formual..
then its ok now

You'll find that if you enter the cell, select all the text (copies of the formulae), cut it, press Enter, then go to another cell and paste what you've got, you'll get seven or eight slightly different versions of the formula which all give the same result.

Regards, TMS