Microsoft Excel Function.?

I am trying to make a function on Microsoft Excel that has a double criteria. A1 has to be bigger than A2, and B2 has to be bigger then A1. If it passes both of those criteria then I need it to have the words C1 has. If it doesn't, I need it to say the words that C2 has. Here is what it looks like.

.......A.......B........C

1....#.........#.......Words

2....#.........#.......Words

3........................................

The best answer will be first or the best one that works for me.

Microsoft Excel Function.?abtuvurys 2005

Put the following in C1:

=IF(AND(A2%26gt;A1,B1%26gt;B2),"Yes","No")

EDIT: Thanks to Anna and genericman1998 for rechecking my work. What I posted initially didn't work, so Jarhead posted "didn't work". The formula above is actually an edit but I didn't specificy it as being so - sorry for the confusion.

Microsoft Excel Function.?antivirus programs

I tested batmaing's formula (Answer #1) in a spreadsheet and it is working for me.

Jarhead, what values/formulas do you have in cells A1,A2,B1,B2 that the formula doesn't work for you?

Edit added: batmaing thanks for the clarification. Now all that remains to do is for Jarhead to try the corrected formula for himself.
The previous answer should have worked, based on the second explanation of what you are looking for. The only reason that I can think of that it would not be working for you would be because of rounding issues, which would make it look like the two values are equal when in reality, they are not. If this is the case, and you want to compare the rounded values, you can use the ROUND function in your formula - replace each cell reference in the previous answer with "ROUND(cell, n)" where "cell" is the cell reference and "n" is the number of decimal places to round to.