Help with formula please...

Hi all,

Could anyone help with this formula?

http://www.neilcarden.pwp.blueyonder...s%20scheme.xls

I want to work out the percentage of a salary based on a target
achevied or not. Please have a look at the example.

If someone reaches 83% of target, then it falls into the 81-90% bracket
and they receive 2% of their salary, which populates in the bonus
acheived cell.

However if they acheive 93%, it falls under the 3% bracket etc...

Sound simple, but i can't fathom it out...

Thanks
Neil


--
neilcarden

Without looking at your link
=if(a190,3,if(a180,2,etc))

--
Don Guillett
SalesAid Software

"neilcarden" wrote in message
...

Hi all,

Could anyone help with this formula?

http://www.neilcarden.pwp.blueyonder...s%20scheme.xls

I want to work out the percentage of a salary based on a target
achevied or not. Please have a look at the example.

If someone reaches 83% of target, then it falls into the 81-90% bracket
and they receive 2% of their salary, which populates in the bonus
acheived cell.

However if they acheive 93%, it falls under the 3% bracket etc...

Sound simple, but i can't fathom it out...

Thanks
Neil


--
neilcarden

I looked at your example.

Format cells C8:C10 as percent so to correlate to the sales percent.
Title these as Minimum or whatever as a reminder. Only enter the
minimum needed for the bonus, don't enter a range.

Formula in cell H7 is then =VLOOKUP(G4,C810,2)*D4

Without having the last argument (True or False) in the Vlookup the
table C810 must be sorted ascending as the Vlookup will return the
value in the range D810 that corresponds to the largest value in
C8:C10 that is less than the value found in cell G4.


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=467483