one way:

B1: =IF(A110,5%,IF(A19,4%,IF(A18,3%,0)))

Good luck.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=480863