=IF(AND(A13,A1<6),"Q","Unspecified Value")

"dstiefe" wrote in message
...
I want to use the "if and" statement

so i want to put in a cell that if a number in another column is greater
then 3 and less then 6 to put the letter Q

Thank you