excel formula reference

A comparison with the number of B number, the number of A number of B, if [105% -95%] range, 2 points; and 105% compared to the number of B (ie (A-105% * B) / B) per 1% deduction of 0.2 points higher, buckle up completed; and B compared with 95% (ie (A-95% * B) / B) for every 1% was 0.1 points lower, the lowest deduction to 0.for this passage, how to use formulas in excel, said out? Please! ! ! ~~~~~ Thank you, the urgent

hypothetical data in the A1 B1 enter the formula in C1:= MAX (IF (A1/B1 <0.95,2 +10 * (A1-95% * B1) / B1, IF (A1 / B1 <= 1.05,2,2-20 * (A1-105% * B1) / B1)), 0)

Thank you, big help, and also thank other friends, but I am so dotted, I'm sorry,

hypothetical data in A1 B1C1 enter = IF (A1/B1 <0.95,2 +10 * (A1-95% * B1) / B1, IF (A1/B1 1.05,2-20 * (A1-105% * B1) / B1)))

C1 enter the following formula = IF (OR (A1> = B1 * 1.15, A1 = 0.95 * B1, A1 1.05 * B1, 2 – (A1/B1-1.05) * 100 * 0.2,2 + ( A1/B1-0.95) * 100 * 0.1)))

= IF (AND (A1 B1 * 0.95), 2, IF (A1> B1 * 1.05, IF (2 – (A1 -1.05 * B1) / B1 * 0.2 * 100 <0,0,2 – (A1-1.05 * B1) / B1 * 100 * 0.2), IF (2 – (A1-0.95 * B1) / B1 * 100 * 0.2 <0,0,2 – (A1-0.95 * B1) / B1) * 100 * 0.2))

= IF (A1> B1 * 1.05, IF (2 – (A1-B1 * 1.05) / B1 * 100 * 0.2 <0,0,2 – (A1-B1 * 1.05) / B1 * 100 * 0.2), IF (A1 <B1 * 0.95, IF (2 – (B1 * 0.95-A1) / B1 * 100 * 0.1 <0,0,2 – (B1 * 0.95-A1) / B1 * 100 * 0.1), 2))