View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default HELP with Rounding

If you want everything to be rouded up to the nearest integer, then:

=roundup(A1,0)

HTH,
Paul

"Sandi" wrote in message
...
I have a spreadsheet with numbers that appear as so:

2.1
2.5
3.2
2.1

I used the ROUND function to round the numbers but for the 2.1 it takes it
down to 2. I need it to bring it back up to 3. Is that possible. Any
help
will be appreciated.
--
Sandi Gardner