Afternoon,

For this example say the target of keyed deals is 100.

The targets are say 10p for each app keyed for the first 100 (Up to
100% of target)

From there up to 125% of target they get 25p per app keyed.... So if
they keyed 125% to target they would receive 100*0.10p and 25*0.25p.

So if they keyed 110% to target the would get 100*0.10p and 10*0.25p.

Over 125% up to 150% they get 0.75p per app keyed. so if they keyed 130
deals (130% to target) they would get 100*0.10p - 25*0.25p and 5*0.75p
towards their target...

And so it grows in stages.... How can i get excel to get this to sum
automatically...?

Thanks guys,

Mike


--
Mikey2005
------------------------------------------------------------------------
Mikey2005's Profile: http://www.excelforum.com/member.php...o&userid=31316
View this thread: http://www.excelforum.com/showthread...hreadid=515756