EXCEL formula: set formula

EXCEL formula:the formula set, when a staff to complete the task of the 100% bonus of 1,000 yuan, higher OR reduced by 1% increase in prize money OR lower 10.Formula for how?

assume that the completion rate in the column A, column B in prize money.

in B2 enter:

= (A2 * 1000)

it.A1 set for the completion of the task rate, B2-deserved reward for.
formula:= (A1-100%) * 10 +1000
trial absolutely correct! ! ! B set as the completion of the progress of the percentage of C-based

as several bonus:
C2 = B2 * 1000
then drag down the formula to