Excel IF function HELP

Question

I'm having trouble with two Excel IF functions. The ratings described are Effectiveness(H7), Efficiency(I7), and Quality(J7). Salary is in G7.

1. If all three ratings are 90 or above, then the employee receives a bonus of 20% of their base salary. Otherwise, if all three ratings are 85 or above then the employee receives a bonus equal to 10% of their base salary. Otherwise, the employee does not receive any bonus. 

I've tried =IF(H7:J7>90,G7*0.2,IF(H7:J7>85,G7*0.1,0)) and get #VALUE!

2. If all three ratings are above 90, then the employee receives a bonus equal to 25% of her base salary. Otherwise, if at least one of the ratings is above 85 and none of the ratings are below 70, then the employee receives a bonus equal to 12% of their base salary. Otherwise, if all three ratings are 80 or above then the employee receives a bonus equal to 5% of their base salary. Otherwise, if at least one of the ratings is above 80, then the employee receives a bonus equal to 2.5% of their base salary. Otherwise, the employee does not receive any bonus (zero dollars). 

Any help would be appreciated!

Answer 1

=IF(AND(H7>=90,I7>=90,J7>=90),G7*0.2,IF(AND(H7>=85,I7>=85,J7>=85),G7*0.1))

2.

=IF(AND(H11>=90,I11>=90,J11>=90),G11*0.25,IF(OR(H11>=70,I11>=70,J11>=70),G11*0.12,IF(AND(H11>=80,I11>=80,J11>=80),G11*0.05,IF(OR(H11>=80,I11>=80,J11>=80),G11*0.025,))))

Answer 2

Try the following.

=IF(COUNTIF(H7:J7,">=90")=3,G7*0.2,IF(COUNTIF(H7:J7,">=85")=3,G7*0.1,0))