% choices

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

Perfect! thanks for you help,most appreciated.

cheers

Dan