To answer your first part, try the following formula:

=IF(A2=H2, A2*0.005, IF(A2=I2, A2*0.01, "A2 doesn't not equal H2 or
I2"))

To do the second part, you must use VBA.. is that what you want?


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=555635