Please help with If formula

[microhunt]

I would apprecaite anyone who can help me with IF formula.

My formula is in cell "A4"

If T4 is false and B4 or N4 is greater than zero then output "K4" If T4 is false and B4 and N4 or both blank then output nothing just blank.

If T4 is True and N4 or O4 is greater than zero then equals "K4" If T4 is True and N4 and O4 or both blank then output nothing just blank.

Thank You

 

[microhunt]

I have worked out part of it

=IF(OR(T4="TRUE",N4>0,O4>0),K4,"")

 

[smozgur]

Your conditions are like the following:

IF T4 is False
  IF B4 or N4 is greater than zero then output "K4"
  ELSE IF B4 and N4 or both blank then output nothing just blank (this is actually B4 or N4 is blank)
  ELSE ???
ELSE (Which is T4 is True case)
  IF N4 or O4 is greater than zero then equals "K4"
  ELSE IF N4 and O4 or both blank then output nothing just blank (this is actually N4 or O4 is blank)
  ELSE ???
END IF

You see? There are two uncovered conditions. You need to return something if both conditions return false, otherwise, for example, you'll see #NA if T4 is false, and B4 and N4 are zero or less.

The following formula works with Excel version 2016 and above (because of the IFS function). You can see how I covered the ELSE condition by using the last condition as TRUE in the IFS function.

=IF(T4=TRUE,
    IFS(OR(B4>0, N4>0), K4, OR(ISBLANK(B4), ISBLANK(N4)), "", TRUE, "MISSING CONDITION"),
    IFS(OR(N4>0, O4>0), K4, OR(ISBLANK(N4), ISBLANK(O4)), "", TRUE, "MISSING CONDITION")
)

Let us know if you are using an earlier version of Excel. IFS function can be changed by using nested IF functions.