maybe match, maybe sumproduct hmmmmmm
Hi, try this,
=IF(Sheet2!$B$2Sheet1!B2,IF(Sheet2!$B$2<Sheet1!D2 ,Sheet1!C2,IF(Sheet2!$B$2<Sheet1!F2,Sheet1!E2,Shee t1!G2)),"Lowest Level not Achieved")
Also make sure in your columns "Low", "Mid" and "High" that you put the
upper limit of that category's sales requirement e.g.
LOW MID HIGH
100 500 1000
If this helps please click "Yes"
<<<<<<<<<<<
" wrote:
Ok I Have a bonus stucture,
It goes on (12) 4 week cycles and and sales have to increase over the period
to hit
loest level of bonus.
Ok to make it real easy, lets so
Cola colb colc cold cole
colf colg
Period / low produciton / bonus /mid produciton /bonus /High production / b
1 100 $10 bonus, 100 <5000 $20 bonus 1000
$30 b
2 200
3
and lets say that sheet 2 A1= the period # and b2= the sales $
Pelase advsie
|