M
Marek
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
107.55 would round up to 110
53.55 would round up to 55
D
Domenic
Try...
=CEILING(A1,5)
Hope this helps!
=CEILING(A1,5)
Hope this helps!
B
Bob Phillips
I love the way the subject says round up to the nearest 10, whilst the body
says the nearest 5 <G>
Bob
says the nearest 5 <G>
Bob
D
Domenic
You know...I didn't even catch that. I guess I'm still half asleep. 
B
Bob Phillips
Good job you didn't respond to the subject then <BG>
Bob
Bob