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