SOLVED

Excel IF

%3CLINGO-SUB%20id%3D%22lingo-sub-2991365%22%20slang%3D%22en-US%22%3EExcel%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2991365%22%20slang%3D%22en-US%22%3E%3CP%3ETeam%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20following%20formulas%2C%20Based%20on%20column%20BW5%20result%20the%20output%20is%20displaying.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(%24BW5%3D%22No%22%2CSUMIF('Revenue%20Cust%20(Margin%20Minder)'!%24BN%3A%24BN%2C'Main%20Data'!%24EN5%2C'Revenue%20Cust%20(Margin%20Minder)'!B%3AB)%2CSUMIF('Revenue%20Group%20(Margin%20Minder)'!%24BN%3A%24BN%2C'Main%20Data'!%24EN5%2C'Revenue%20Group%20(Margin%20Minder)'!B%3AB))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERequirement%20is%20.%26nbsp%3B%20This%20whole%20formula%20should%20be%20valid%20only%20if%20column%20EU5%26nbsp%3B%20is%20%22YES%22%20.%20If%20column%20EU5%20value%20is%20%22No%22%20then%20above%20formula%20should%20not%20valid.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2991365%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2992575%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2992575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1225764%22%20target%3D%22_blank%22%3E%40Micro440%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(EU5%3D%22Yes%22%2CIF(%24BW5%3D%22No%22%2CSUMIF('Revenue%20Cust%20(Margin%20Minder)'!%24BN%3A%24BN%2C'Main%20Data'!%24EN5%2C'Revenue%20Cust%20(Margin%20Minder)'!B%3AB)%2CSUMIF('Revenue%20Group%20(Margin%20Minder)'!%24BN%3A%24BN%2C'Main%20Data'!%24EN5%2C'Revenue%20Group%20(Margin%20Minder)'!B%3AB))%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Team,

 

I have following formulas, Based on column BW5 result the output is displaying. 

 

=IF($BW5="No",SUMIF('Revenue Cust (Margin Minder)'!$BN:$BN,'Main Data'!$EN5,'Revenue Cust (Margin Minder)'!B:B),SUMIF('Revenue Group (Margin Minder)'!$BN:$BN,'Main Data'!$EN5,'Revenue Group (Margin Minder)'!B:B))

 

Requirement is .  This whole formula should be valid only if column EU5  is "YES" . If column EU5 value is "No" then above formula should not valid. 

 

Please advise. 

2 Replies
best response confirmed by Micro440 (Occasional Contributor)
Solution

@Micro440 

Try

 

=IF($EU5="Yes",IF($BW5="No",SUMIF('Revenue Cust (Margin Minder)'!$BN:$BN,'Main Data'!$EN5,'Revenue Cust (Margin Minder)'!B:B),SUMIF('Revenue Group (Margin Minder)'!$BN:$BN,'Main Data'!$EN5,'Revenue Group (Margin Minder)'!B:B)),"")

Thank you