formula to round up?
 

Hello.

I am working with temperature data in celsius and fahrenheit. I just
wondered if you know how I can set the data to round up to the nearest
0.5 F? I.E. if it's 76.3 F it would round it to 76.5, or 81.8 would
go to 82.0 etc.

Cheers

John

Will this work for you?:
=CEILING(A1,0.5)

Regards,
Ron

=CEILING(A1,0.5)
--
Greetings from New Zealand
Bill K

"John" wrote in message
...
Hello.

I am working with temperature data in celsius and fahrenheit. I just
wondered if you know how I can set the data to round up to the nearest
0.5 F? I.E. if it's 76.3 F it would round it to 76.5, or 81.8 would
go to 82.0 etc.

Cheers

John