Excel formula involving comparisons of numbers

[excelactuary]

Hello!

My problem looks as follows:

In columns D and E I'm having numbers. Let's call the numbers in column D with "x" and the numbers in column E with "y". I want to do the following operation in every row: if x>=3 and y>3, then I want to have "1" written in column F. If x>=3 and y<3, I want "2" in F. If x<3 and y>=3, then I want "3" in the column F. At last, if x<3 and y<3, I want "4" in F.

For Instance:

D E F

3 2 2
3 5 1
1 5 3


How do I have to input the formula, to achieve the desired result?

Thank you very much for your time!

[dluhut]

Assuming your first row is 1. Thus put this on F1.

=IF(AND(D1>=3, E1>3), 1, IF(AND(D1>=3, E1<3), 2, IF(AND(D1<3, E1>=3), 3, IF(AND(D1<3, E1<3), 4, "Incomplete Formula"))))

[excelactuary]

Thank you very much!