I NEED HELP ON THE FOLLOWING
SALES PRODUCTIVITY Attendance Total
PAUL SMITH 5 90% 100% £50

PRODUCTIVITY
89% OR LESS = £5
90% OR ABOVE = £10

Attendance
99% OR LESS = £5
100% OR ABOVE= £5

BUT IF THE HIT ONE AND NOT THE OTHER THEY STILL GET £5.00

EX--


SALES PRODUCTIVITY Attendance Total
PAUL SMITH 5 89% 100% £25

SALES PRODUCTIVITY Attendance Total
PAUL SMITH 5 90% 98% £25


So i need a formula that would work this out,

so if the hit both target they will get £10 for each sale

if they hit one and not the other they will get £5 not £10

if they not hit any they get £5

can you help me on this