pothgulla Wrote:
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
Construct a table like so:
1. Enter the first set of numbers (5, 5.5, 6 ... 10) starting in Cell
D1, going down until Cell D11.
2. Enter the second set of numbers (1, 1.5, 2 ... 4) starting in Cell
E1, going down until Cell E11
Enter this formula in Cell C1:
=IF(B1=\"\",\"\",VLOOKUP(C1,D1:E11,2,0))
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=397077