Hi friends,
In the formula the if conditions for cell ‘g8, m8, s8, y8, ae8, ak8, aq8, aw8, bc8 are >=3 then I want to enter 15 in cell h8 if cell g8 contains 20. I want to use countif function to count >=3 to achieve the target. I also want to shorten the formula because it’s too long and I have to add some more conditions if the cell g8 contains 21 to 34. The formula is in cell h8.

The formula is as follows:

=IF(G8=20,IF(M8>=35,IF(S8>=35,IF(Y8>=35,IF(AE8>=35,IF(AK8>=35,IF(AQ8>=18,IF(AW8>=18,IF(BC8>=18,15)))))))))
Any help will be appreciated.

Thank you.