| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet Function
I need a function that will round my answer up to a number divisible by 500.
I am using EXCEL 2002 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'name of spreadsheet' function... please help | Excel Worksheet Functions | |||
| Payroll spreadsheet function help | Excel Worksheet Functions | |||
| Spreadsheet Function | Excel Worksheet Functions | |||
| FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
| spreadsheet function | Excel Discussion (Misc queries) | |||
Linear Mode
