=if(g5=0.997,c2,if(g5=0.98,d2,if(g5=0.96,e2,if( g5<0.96,1))))


--
mimmson
------------------------------------------------------------------------
mimmson's Profile: http://www.excelforum.com/member.php...o&userid=23809
View this thread: http://www.excelforum.com/showthread...hreadid=374637