IF statement problem

[bibstar03]

There are 3 cells invlved in my problem, one cell which holds gender and one which holds age, in the last cell i want either yes or no to appear.

it should read yes if male betweem 18 and 40 and no if female or not within the age group.

how can i do this if statement based on 2 bits of data?

thank you

 

[Norie]

Try this

=IF(AND(A1="M", B1>18, B2<40), "Yes", "No")

 

[bibstar03]

bril

thanks very much