I am a 61 year old beginner !!!

I need help to write a formula to get the following result.

B1=5 then C1 should read 1
B1=5.5 then C1 should read 1.5
B1=6 then C1 should read 2
B1=6.5 then C1 should read 2.5
B1=7 then C1 should read 3
B1=8 then C1 should read 2
B1=8.2 then C1 should read 2.2
B1=8.3 then C1 should read 2.3
B1=8.5 then C1 should read 2.5
B1=9 then C1 should read 3
B1=10 then C1 should read 4

I hope someone could help me out.

Thanks

pothgulla


--
pothgulla
------------------------------------------------------------------------
pothgulla's Profile: http://www.excelforum.com/member.php...o&userid=26431
View this thread: http://www.excelforum.com/showthread...hreadid=397077