Rounding up & down

I have many pages in excel with hundreds of prices. I need a formula to
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.00


---
Message posted from http://www.ExcelForum.com/

Have a look in HELP index for ROUNDUP

--
Don Guillett
SalesAid Software

"cmlm " wrote in message
...
I have many pages in excel with hundreds of prices. I need a formula to
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.00


---
Message posted from http://www.ExcelForum.com/

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



"cmlm " wrote in message
...
I have many pages in excel with hundreds of prices. I need a formula to
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.00


---
Message posted from http://www.ExcelForum.com/

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 :-)
----------------------------------------------------------------------------



"Dave R." wrote in message
...
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



"cmlm " wrote in message
...
I have many pages in excel with hundreds of prices. I need a formula to
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.00


---
Message posted from http://www.ExcelForum.com/





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004

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

Vaya con Dios,
Chuck, CABGx3



"cmlm " wrote in message
...
I have many pages in excel with hundreds of prices. I need a formula to
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.00


---
Message posted from http://www.ExcelForum.com/

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

In article ,
"CLR" wrote:

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

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


"JE McGimpsey" wrote in message
...
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

In article ,
"CLR" wrote:

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