Help with an excel formula

[813615]

Morning all
I'm stuck on a trigger cell I need to look at a number of possible outcomes before returning a value of either "1" or "0".
Currently it reads if W5>0 and X5>0 return the value of 1 if true or 0 if false, this works great but I want to add a further condition of saying the above or if another cell (AA5) has a value of 1 then also return the value of 1 if true or 0 if false?
This is the formula I've tried after countless google hours and trying different options without getting an error message but it returns the value of "FALSE" instead of a number?
=IF(ISBLANK(A5),"",IF(OR(AA5=1),IF(AND(W5>0,X5>0),1,0)))
Any help would be greatly appreciated.
Many thanks
Lee

[alrodopial]

=IF(ISBLANK(A5),"",IF(OR(AA5=1,AND(W5>0,X5>0)),1,0))

[ferrao2003]

=+IF(AND(W5>0;X5>0;AA5>0);1;0)

[alrodopial]

by placing the mouse at the ie second "IF" inside the formula and then pressing the "fx" symbol at the left you display the
current function ("second "IF" in your formula) and it's arguments. This way you can easily see where you're wrong or if you missed an argument

[813615]

Many thanks guys, formula worked fine much appreciated.
Lee

[813615]

Hi guys
Using this formula (thanks for the help before)
=IF(ISBLANK(A5),"",IF(AND(W5>0,Z5<=-60),1,0))
And I want to add another criteria that says the above as well as if the value of Z5>5 also return a value of 1 what would I add, tried again lots of combinations but keep getting the error message?
So basically I want the cell to return a value of "1" if the value in cell W5 is greater than zero and the value in Z5 is either less than 60 or greater than 5?
Many thanks again
Lee