Hi guys,i'm hoping i've got a simple question that i'm just being thick about, kind of can't see the wood for the trees...

I'm trying to create a worksheet that selects a level of payment per item dependant on what % of target has been achieved.

e.g. - if the % of target achieved is up to 80% - remuneration per unit =£75, if the % is between 81%-100% then its £100 per unit, if its 101% + then its £125 per unit.

I can easily calculate what the percentages are,i just cant fathom out how to get the if,either or bit of the formula worked out.

Please,any help will be appreciated...

Dan