Spreadsheet Function
 

I need a function that will round my answer up to a number divisible by 500.
I am using EXCEL 2002

Spreadsheet Function
 

MROUND

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dave" wrote in message
...
I need a function that will round my answer up to a number divisible by
500.
I am using EXCEL 2002

Spreadsheet Function
 

Try

=CEILING(your_formula,500)

Mike

"Dave" wrote:

I need a function that will round my answer up to a number divisible by 500.
I am using EXCEL 2002