Any chance anyone can help me with this question.
I dont want to double post and I am not getting any reposnse

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


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:




so close,
But that two varible on sheet two;
A1 the periof of the bonus
b2 the amount on $ need to achieve the bonus.

this function works great for period 1, but there are 12 peiod.
morover a1 has text 1st, 2nd, 3rd and on...

The tbl arrey Sheet
col a; the period
col b, the lowest bonus scale
col c, the bonus amount

col d, the middle bonus scale
col e, the bonus amount
col f, the highest bonus scale
col g, the bonus amount

The tble woudl look like this
1st $3250 b$500 $4500 b$1000 $7500 b$2000
2nd$5000 b$500 $7000 b$1000 $10000 b$2000
3rd $600 b$500 $8000 b$1000 $14000 b$ 2000
and on

"BSc Chem Eng Rick" wrote:


"Gary''s Student" wrote:




"T. Valko" wrote:

This seems to happen about once a month.

--
Biff
Microsoft Excel MVP


"Peter T" <peter_t@discussions wrote in message
...
X-posted to .excel.programming, .misc, .charting, .worksheet.functions

These Excel groups, indeed all the "microsoft.public" groups are available
via the Communities web interface, "WebNews"

http://www.microsoft.com/communities...s/default.aspx

- and via NTTP newsreaders, eg Outlook Express, Windows Mail, Firefox.
Most of the numerous web mirrors, eg Google-groups, can be considered as
NTTP. (In passing, some of the mirrors tend to give a misleading
impression they host these groups themselves.)

Currently, possibly since 13-Oct, most if not all NTTP posts are not being
made visible to WebNews. So anyone posting on WebNews probably will not
see replies from NTTP posters.

NTTP posters seem to be able to see WebNews posts.

A clue as to how the post was sent is to look at the headers, if you see
the following it's probably WebNews and the poster may not see your reply.
X-Newsreader: Microsoft CDO for Windows 2000

Regards,
Peter T (MVP)




.