If Condition with multiple column

Copper 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 .