Dysfunctional nested if

[Leathermyth]

I used to know how to do this! Last month, actually. But my brain has dropped something from the formula.

So as to not confuse anyone with my dysfunctional function, here's what I am trying to do:

If B5 is greater than 0 and G5 = "X" or H5 = "X" then L5, if not, 0

(or by column titles) If in column "NAME" there is a name, and either column "CHILD OVER 6," or in column "CHILD UNDER 6," has been marked, then the information in column "HOME VISITS" needs to be used; if not, enter 0

[Richard Buttrey]

Hi

Please Login or Register  to view this content.

[bebo021999]

Maybe:
=IF(AND(B5>0,OR(G5="X",H5="X")),L5,0)

[Leathermyth]

Thank you! I was so focused on what I was doing wrong with the nested and/or that I never even thought of using the XOR.

[Leathermyth]

Thank you! Richard had reminded me I could use XOR, but yours lets me see where I was messing up. I kept putting a ) after the B5>0. I just couldn't see it.