Thread
:
Rounding Up
View Single Post
#
2
Posted to microsoft.public.excel.programming
Sandy Mann
external usenet poster
Posts: 2,345
Rounding Up
Check out the CEILING() function.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Mike" wrote in message
...
Im needing a code to round up not down
100.1 = needs to be 101
100.2 = needs to be 101
100.9 = needs to be 101
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann