 # 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 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

# Re: If Condition with multiple column

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

# Re: If Condition with multiple column

Thank you. But i cam getting following error ,

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

Error is #DIV/0!

# Re: If Condition with multiple column

That's not what I suggested. I proposed

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

# Re: If Condition with multiple column

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 .