Directions to setup a reference table

[Wayland3r]

I am setting up a buget plan that has 25 different formulas depending on the Sales persons split plans. What I would like to setup is a table or something that lists the 25 different formulas possible for 250 different agents.

The formulas look like this:
=IF(Q40<65000,Q40*60%,39000)+IF(Q40>85000,14000,IF(Q40>65000,(Q40-65000)*70%,0))+IF(Q40>100000,11250,IF(Q40>85000,(Q40-85000)*75%,0))+IF(Q40>100000,(Q40-100000)*90%,0)

and there is 25 different levels.

In one column we enter the Plan ID# and the Q40 would be the agents expected sales income.

What direction should I be heading in? And if somoene could post an example I would be estatic.

Thanks,

Wayland3r

[Leith Ross]

Hello Wayland3r,

As I understand your post, and I hope I am wrong on this, you have 25 possible levels for each salesperson? Would you clarify this point please?

Thanks,
Leith Ross