If Condition with multiple column

%3CLINGO-SUB%20id%3D%22lingo-sub-3002439%22%20slang%3D%22en-US%22%3EIf%20Condition%20with%20multiple%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3002439%22%20slang%3D%22en-US%22%3E%3CP%3EExperts%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Micro440_0-1637774300379.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329207i8D5FB284B129FE2A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Micro440_0-1637774300379.png%22%20alt%3D%22Micro440_0-1637774300379.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFollowing%20formula%20for%20column%20N%20and%20Row%208%20%3DIFERROR(IF(%24J8%3D0%2C0%2C%24J8%2F%24BX8*CA8)%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERequirement%20is%20%3A%26nbsp%3B%20Example%20for%20row%208%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20column%20EK%20value%20is%200%20then%20Column%20N%20should%20bring%20the%20value%20of%20column%20I.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExisting%20formula%20for%20column%20N%20is%26nbsp%3B%3DIFERROR(IF(%24J8%3D0%2C0%2C%24J8%2F%24BX8*CA8)%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20achieve%20this.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3002439%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3003113%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Condition%20with%20multiple%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3003113%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%3E%3DIF(%24EK8%3D0%2C%24I8%2CIF(%24BX8%3D0%2C0%2C%24J8%2F%24BX8*%24CA8))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3015287%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Condition%20with%20multiple%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3015287%22%20slang%3D%22en-US%22%3EThank%20you.%20But%20i%20cam%20getting%20following%20error%20%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3DIF(%24EL608%3D0%2C%24G608%2CIF(%24J608%3D0%2C0%2C%24J608%2F%24BX608*%24DE608))%3CBR%20%2F%3E%3CBR%20%2F%3EError%20is%20%23DIV%2F0!%3C%2FLINGO-BODY%3E
Occasional Contributor

Experts,

 

 

Micro440_0-1637774300379.png

 

Following formula for column N and Row 8 =IFERROR(IF($J8=0,0,$J8/$BX8*CA8),0)

 

Requirement is :  Example for row 8 : 

If column EK value is 0 then Column N should bring the value of column I.

 

Existing formula for column N is =IFERROR(IF($J8=0,0,$J8/$BX8*CA8),0)

 

How to achieve this. 

4 Replies

@Micro440 

=IF($EK8=0,$I8,IF($BX8=0,0,$J8/$BX8*$CA8))

Thank you. But i cam getting following error ,

=IF($EL608=0,$G608,IF($J608=0,0,$J608/$BX608*$DE608))

Error is #DIV/0!

@Micro440 

That's not what I suggested. I proposed

 

=IF($EK8=0,$I8,IF($BX8=0,0,$J8/$BX8*$CA8))

Hi hans . yes just i given the example. And your solution got worked. With your proposed i have added the iferror  =iferror(IF($EL608=0,$G608,IF($J608=0,0,$J608/$BX608*$DE608)),0)

 

Looks fine. Thank you for your solution .