Rounding up & down

[cmlm]

I have many pages in excel with hundreds of prices. I need a formula t
round the price up or down.

For example: R 1465.55 rounded up to R 1495.00
R 1419.26 rounded down to R 1395.00
R 278.25 rounded up to R 295.00
R 749.00 rounded down to R 695.0

 

[Don Guillett]

Have a look in HELP index for ROUNDUP

 

[Dave R.]

Without the R (good idea)--

=ROUND(INT(A1)/100,0)*100-5

If you have the R in the cell (bad idea, by the way)--

=ROUND(INT(--SUBSTITUTE(A1,"R",""))/100,0)*100-5

 

[Ken Wright]

Without the R (good idea)--

LOL - Not if you're South African the R is the same as a dollar or pound
sign and in this case is possibly just a currency format.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Without the R (good idea)--

=ROUND(INT(A1)/100,0)*100-5

If you have the R in the cell (bad idea, by the way)--

=ROUND(INT(--SUBSTITUTE(A1,"R",""))/100,0)*100-5

 

[CLR]

Maybe something like =MROUND(A1,100)-5

Vaya con Dios,
Chuck, CABGx3

 

[JE McGimpsey]

Since MROUND is an Analysis Toolpak Add-in function, when rounding to a
power of 10, there's no advantage to using MROUND over ROUND:

=ROUND(A1,-2) - 5

 

[CLR]

Thanks JE............

I still learn something every day in these newsgroups. Now the OP has a
choice of several working answers...........thats the wonderfulness of it
all............

Vaya con Dios,
Chuck, CABGx3