If 'true' perform 2 different formulas, if 'false' return blank

[gtd526]

Hello,
I'm using the following formula. If the first 'if' is true, then perform 2 separate If's, if either of the 2 if's are true, then return 'pd'. which it does correctly.
If the first if is false then return "", currently it returns 'false'.
How can I return "" when the first If is false?

IF(MONTH(K10)&YEAR(K10)=MONTH('BOA-9547'!$D$3)&YEAR('BOA-9547'!$D$3),IF(COUNTIFS('BOA-9547'!$A$3:$A$33,$N$8,'BOA-9547'!$D$3:$D$33,">0"),"pd",IF(COUNTIFS('BOA-9547'!$G$3:$G$33,$N$8,'BOA-9547'!$J$3:$J$33,">0"),"pd","")))

Thank you

 

[Sergius]

This should help.

=IF(MONTH(K10)&YEAR(K10)=MONTH('BOA-9547'!$D$3)&YEAR('BOA-9547'!$D$3);IF(COUNTIFS('BOA-9547'!$A$3:$A$33;$N$8;'BOA-9547'!$D$3:$D$33;">0");"pd";IF(COUNTIFS('BOA-9547'!$G$3:$G$33;$N$8;'BOA-9547'!$J$3:$J$33;">0");"pd";""));"")

 

[gtd526]

This should help.

=IF(MONTH(K10)&YEAR(K10)=MONTH('BOA-9547'!$D$3)&YEAR('BOA-9547'!$D$3);IF(COUNTIFS('BOA-9547'!$A$3:$A$33;$N$8;'BOA-9547'!$D$3:$D$33;">0");"pd";IF(COUNTIFS('BOA-9547'!$G$3:$G$33;$N$8;'BOA-9547'!$J$3:$J$33;">0");"pd";""));"")

I replaced your semicolons with commas and it worked.
Thank you

 

[Peter_SSs]

I replaced your semicolons with commas and it worked.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

BTW, you could eliminate both of those later IF functions and shorten your formula a bit as follows.

=IF(AND(TEXT(K10,"my")=TEXT('BOA-9547'!$D$3,"my"),COUNTIFS('BOA-9547'!$A$3:$A$33,$N$8,'BOA-9547'!$D$3:$D$33,">0")+COUNTIFS('BOA-9547'!$G$3:$G$33,$N$8,'BOA-9547'!$J$3:$J$33,">0")),"pd","")