| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rounding to the nearest 100
I will be very grateful for the code to round a number to the nearest 100
Many thanks -- with kind regards Spike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
rounding to the nearest 100
I neglected to say i will be grateful for the code for both negative numbers
and positive numbers, i have used the floor or ceiling function to date on positives but does not appear to work on negatives -- with kind regards Spike "Spike" wrote: I will be very grateful for the code to round a number to the nearest 100 Many thanks -- with kind regards Spike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
rounding to the nearest 100
Hi Spike,
Why not just use the Round() function? If in VBA, you can access it from Application.Worksheetfunctions. HTH -- Regards, Zack Barresse, aka firefytr MsgBox "fire" & "fytr" & Chr(64) & "vba" & "express" & Chr(46) & "com" "Spike" wrote in message ... I will be very grateful for the code to round a number to the nearest 100 Many thanks -- with kind regards Spike |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
rounding to the nearest 100
Thanks, i think i tried this initially, anyway using floor getting what is
required -- with kind regards Spike "Zack Barresse" wrote: Hi Spike, Why not just use the Round() function? If in VBA, you can access it from Application.Worksheetfunctions. HTH -- Regards, Zack Barresse, aka firefytr MsgBox "fire" & "fytr" & Chr(64) & "vba" & "express" & Chr(46) & "com" "Spike" wrote in message ... I will be very grateful for the code to round a number to the nearest 100 Many thanks -- with kind regards Spike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding up to nearest 500 | Excel Discussion (Misc queries) | |||
| Rounding Up or Down to nearest $10 | Excel Discussion (Misc queries) | |||
| rounding to nearest 100 | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Rounding to Nearest 250 | Excel Worksheet Functions | |||
Linear Mode
