Nov 24 2021 09:21 AM
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.
Nov 24 2021 12:22 PM
=IF($EK8=0,$I8,IF($BX8=0,0,$J8/$BX8*$CA8))
Nov 29 2021 10:53 AM
Nov 29 2021 11:23 AM
Nov 29 2021 11:55 AM - edited Nov 29 2021 11:56 AM
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 .