Phil,
I don't see how this fits in with the previous requirement of Anne=1.2.
Confused.

NickHK

"phil2006" wrote in
message ...

Thanks. I have been trying the vlookup with no success! What I need is
an if function that says if the value is 1.49 and <1.51 it gives 1/2,
if the value = 5 it returns 5/1 etc...

Thanks


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=558775