Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Round Up to Nearest 10
Does anyone have any ideas on how to round up to the nearest 5. For example,
107.55 would round up to 110 53.55 would round up to 55 -- Many thanks in advance for any assistance |
#2
|
|||
|
|||
Try...
=CEILING(A1,5) Hope this helps! In article , "Marek" wrote: Does anyone have any ideas on how to round up to the nearest 5. For example, 107.55 would round up to 110 53.55 would round up to 55 |
#3
|
|||
|
|||
I love the way the subject says round up to the nearest 10, whilst the body
says the nearest 5 <G Bob "Domenic" wrote in message ... Try... =CEILING(A1,5) Hope this helps! In article , "Marek" wrote: Does anyone have any ideas on how to round up to the nearest 5. For example, 107.55 would round up to 110 53.55 would round up to 55 |
#4
|
|||
|
|||
You know...I didn't even catch that. I guess I'm still half asleep. :)
In article , "Bob Phillips" wrote: I love the way the subject says round up to the nearest 10, whilst the body says the nearest 5 <G Bob "Domenic" wrote in message ... Try... =CEILING(A1,5) Hope this helps! In article , "Marek" wrote: Does anyone have any ideas on how to round up to the nearest 5. For example, 107.55 would round up to 110 53.55 would round up to 55 |
#5
|
|||
|
|||
Good job you didn't respond to the subject then <BG
Bob "Domenic" wrote in message ... You know...I didn't even catch that. I guess I'm still half asleep. :) In article , "Bob Phillips" wrote: I love the way the subject says round up to the nearest 10, whilst the body says the nearest 5 <G Bob "Domenic" wrote in message ... Try... =CEILING(A1,5) Hope this helps! In article , "Marek" wrote: Does anyone have any ideas on how to round up to the nearest 5. For example, 107.55 would round up to 110 53.55 would round up to 55 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am trying to round up to the nearest 25 cents | New Users to Excel | |||
Round time to nearest quarter hr | Excel Worksheet Functions | |||
How do I format cells to round to the nearest thousands without .. | Excel Discussion (Misc queries) | |||
WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS | Excel Discussion (Misc queries) | |||
WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND? | Excel Worksheet Functions |