=ROUNDUP(A1,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"rexmann" wrote in message
...
Hi all

Does anyone know how to get Excel to round up (regardless of the decimal
point value). Therefore 1.1 would round up to 2.

Any help greatly appreciated

Cheers Rexmann

PS I am running Excel 2002