Rounding a formula to nearest 100 within a cell

[pjfoster]

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.

[tigeravatar]

pjfoster,

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

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

[TMS]

=ROUND(L63*0.95,-2)


Regards, TMS

[Special-K]

Cant you just use

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

[pjfoster]

I have tried all of the above but i continue to get a "FALSE" statement in the cell. I have attached an example file.

Thank you for your help so far.

Phil

[vlady]

delete the 0 in 0.95

makes it .95 only

[daddylonglegs]

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

[vlady]

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

[TMS]

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

[pjfoster]

Removing the "0" seemed to do the trick.

Thank you.