Compare multiple columns

[300m]

I would like to compare multiple columns and if all the results below are true, display the output "1" and if one of them is not true display the output "0".


O7>P7
Q7>R7
S7>T7
AA7> AB7
AG7>AH7


I tried with this formula, but it does not work:
=IF(O7>P7,1,IF(Q7>R7,1,IF(S7>T7,1,IF(AA7>AB7,1,IF(AG7>AH7,1,0)))))


Any help much appreciated.

 

[rallcorn]

Like this?
=IF(AND(O7>P7,Q7>R7,S7>T7,AA7>AB7,AG7>AH7),1,0)

 

[300m]

Yes, it works really well. Thank you very much!
Why does my formula not work?

 

[rallcorn]

If you have Excel 2002 or higher version, have you ever tried stepping through the pieces of your formula using Formula Auditing>Evaluate Formula? That should help you understand the error of your ways. When you're on the cell with formula Excel 2007 use Alt+M+V, in Excel 2002-2003 Tools>Formula Auditing>Evaluate Formula.

Here's what your formula is doing:
O7>P7 then "1" regardless of what is in any of the remaining groups of cells
O7 is NOT > P7 but Q7>R7 then "1" regardless of what is in any of the remaining groups of cells
O7 is NOT > P7 and Q7 is NOT > R7 but S7>T7 then "1" regardless of what is in any of the remaining groups of cells
ect.

 

[300m]

I am on excel for mac 2011, not sure but don't think there is a Formula Auditing>Evaluate Formula. Anyway, thanks a lot for your clear explanation, I appreciate your effort.
Have a nice day!