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

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

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

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

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