Try this:

=if(and(G2<=100,I2=1),73,if(and(G2<=100,I21),115, if(and(G2100,I2=1),130,if(and(G2100,I21),150,"" ))))

It returns a "blnk" cell if none of your conditions are met: ie. I2<1


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=512770