View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nekteo
 
Posts: n/a
Default Greater than, smaller than formula

i hv a question...

Is there any formula in excel that can convert a certain number to a a number
that is greater than the previous number, which is an integer number? for
example:


23.56 convert to 24
24.00 convert to 25
23.12 convert to 24
19.00 convert to 20
42.10 convert to 43

HELP ME!!!