There has to be an easier way to do this.

I have a commission worksheet. In column A I have the revenue. In
column B I'd like to display the payout.

For instance, if cell A1 is 0-14999, B1 should display A1*0%
if cell A1 is 15-19999, B1 should display A1*10%

and so on, including a total of 7 tiers or variables.

Right now I have a terribly long 'If' statement and it is cumbersome to
make any changes.

I am -okay- at VB, but I know nothing about pivot tables, FYI.

Thank you so much!

Jacob