Assuming the values are on row 2, the following formula will calculate the bonuses:
=500*(C2>2.5)+500*(C2>3)+1000*(C2>3.5)+1000*(D2>1) +1000*(D2>2)+500*(D2>3)+500*(D2>4.5)
To have the full value calculated instead of just the bonus, add +29705 to the formula:
=500*(C2>2.5)+500*(C2>3)+1000*(C2>3.5)+1000*(D2>1) +1000*(D2>2)+500*(D2>3)+500*(D2>4.5)+29705
Simply copy down as far as needed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|