Forum Discussion
If Condition with multiple column
Experts, 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 t...
=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!
=IF($EL608=0,$G608,IF($J608=0,0,$J608/$BX608*$DE608))
Error is #DIV/0!
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 .
