IF statement help needed

[andyg55]

I would like to use the following IF statement, but I'm not sure how to...

IF the number in cell G2 is between >=7 and <=9, AND the number in cell H2 is between >=7 and <=9, YES, NO

Is this possible?

AG

[Pete_UK]

Try this:

=IF(AND(G2>=7,G2<=9,H2>=7,H2<=9),"Yes","No")

Hope this helps.

Pete

[OzTrekker]

Try this.

=IF(AND(G2>=7,G2<=9,H2>=7,H2<=9),"Yes","No")

Sorry didn't realise a solution had already been posted.