G
Guest
I have a query that has as one of its fields Total Sales, what I need to do
is add another field called Bonus, however the bonus differs depending on the
amt of the Total Sales. So if a salesman has sales of between $250,000 and
$350,000 his bonus is (Total Sales/1000)*.25, if his sales are between
$350,001 and $450,000 than his bonus is (Total Sales/1000)*.50, and so on.
I can get the formula to work for 1 but don't know how to get it to work on
multiple criteria. The formula I have so far is: Bonus: IIf([Total Sales]
Between 250000 And 350000,[ Total Sales]/10*0.25,[Total Sales]*0). It set it
to return a 0 value if it doesn't meet the criteria. How would I go about
getting it to go through the multiple criteria or should I set a field for
each criteria?
Any help would be greatly appreciated.
Thanks
is add another field called Bonus, however the bonus differs depending on the
amt of the Total Sales. So if a salesman has sales of between $250,000 and
$350,000 his bonus is (Total Sales/1000)*.25, if his sales are between
$350,001 and $450,000 than his bonus is (Total Sales/1000)*.50, and so on.
I can get the formula to work for 1 but don't know how to get it to work on
multiple criteria. The formula I have so far is: Bonus: IIf([Total Sales]
Between 250000 And 350000,[ Total Sales]/10*0.25,[Total Sales]*0). It set it
to return a 0 value if it doesn't meet the criteria. How would I go about
getting it to go through the multiple criteria or should I set a field for
each criteria?
Any help would be greatly appreciated.
Thanks