Without actually looking at it (sorry, I'm a visual person) I couldn't tell
you for certain, although I have a similar spreadhsheet that calculates
incentive pay based on speed, number of errors, type of error, and hours
worked. I used the vlookup function with several tables to accomplish this,
with the idea that if the method of paying the incentive changes, as it does
periodically, I won't have to change the entire spreadsheet. In your case
your IF statement could then reference the proper table based on the product
code. This doesn't use VBA, but it should work.

--
Message posted via http://www.officekb.com