If Condition with multiple column

Question

Experts,&nbsp;&nbsp;&nbsp;Following formula for column N and Row 8 =IFERROR(IF($J8=0,0,$J8/$BX8*CA8),0)&nbsp;Requirement is :&nbsp; Example for row 8 :&nbsp;If column EK value is 0 then Column N should bring the value of column I.&nbsp;Existing formula for column N is&nbsp;=IFERROR(IF($J8=0,0,$J8/$BX8*CA8),0)&nbsp;How to achieve this.&nbsp;

hansvogelaar · Answer

Micro440&nbsp;
=IF($EK8=0,$I8,IF($BX8=0,0,$J8/$BX8*$CA8))

micro440 · Answer

Thank you. But i cam getting following error ,=IF($EL608=0,$G608,IF($J608=0,0,$J608/$BX608*$DE608))Error is #DIV/0!

hansvogelaar · Answer

Micro440&nbsp;
That's not what I suggested. I proposed
&nbsp;
=IF($EK8=0,$I8,IF($BX8=0,0,$J8/$BX8*$CA8))

micro440 · Answer

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

Forum Discussion

If Condition with multiple column

Share

Resources