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

Try using the ROUNDUP() function instead.

=ROUNDUP(A1,0)

HTH,
Elkar


"Sandi" wrote:

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