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