if statement nesting rules

[13lack13lade]

=IF(O5="","","\{NUMPAD ENTER}",IF(P5="","","\{NUMPAD ENTER}")))

Anyone have any idea why this one isnt working? im not very good with where the brackets go.

Basically i want =IF(O5="\{NUMPAD ENTER}"AND(P5=""),"","\{NUMPAD ENTER}")

[justinlucas]

=IF(AND(P5="",O5=""),"VALUE IF TRUE", "VALUE IF FALSE")

If you put in your criteria for P5 in the "" and O5 in the "" then what happens in true and what happens if false, I think this will get you what you are trying to do (if I understand correctly).

Hope this helps,

Justin

[13lack13lade]

=IF(AND(O5="\{NUMPAD ENTER}",(P5="")),"","\{NUMPAD ENTER}")

Worked correctly however is there a way to incorporate if =IF(AND(O5="",P5=""),"","\{NUMPAD ENTER}")) into the same if statement above?

[justinlucas]

I think I understand..... it is 2x If statements.

If both are blank, display nothing. If one is blank, display the statement.

=IF(AND(O5="",P5=""),"",IF(AND(O5="\{NUMPAD ENTER}",(P5="")),"","\{NUMPAD ENTER}"))

Correct??

Justin

[13lack13lade]

absolute legend... i knew i had everything i needed i just didnt know how to put it in the correct syntax - will know for future thanks so much!