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

Super - worked wonderfully. Thanks soooo much!
--
Sandi Gardner


"Bob Phillips" wrote:

=CEILING(A2,1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"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