IF formulas

[pmb81]

Hello, I need help coming up with the proper IF formula for the 2 below scenarios written out in plan English. Any help is appreciated!!

If D3 is greater than or equal to 90% but less than 100%, E3 = 5. If D3 is greater than or equal to 100% but less than 110%, E3 = 15. If D3 is greater than or equal to 110%, E3 = 25. If D3 is less than 90%, E3 = 0.

If L3 is greater than or equal to 90% but less than or equal to 99%, M3 = 5. If L3 is greater than or equal to 100%, M3 = 10. If L3 is less than 90%, M3 = 0.

 

[tigeravatar]

Its basically the same thing, just update the range:
=IF(COUNTIF(W10:W12,0),0,5)

 

[pmb81]

well that certainly make sense! thank you again!

 

[Scott Huish]

If it's just 5s or 0s, you could also do this:

=5*AND(W10:W12)