using "if" and #div/0! in nesting environment gives error

[Karnik]

Hi Experts,

using "if" and #div/0! in nesting environment , unable to overcome the errors as not experienced in nesting commands.

In following unable to put "iferr"

IF((D3-C3)/C3%<=10%,"-10%","")

Please see sample excel file


Thanks in advance,
Karnik

[FDibbins]

SAee if this will get you started...
=IF(C3=0,"",IF((D3-C3)/C3%<=10%,-10%,""))

Note also that I removed the "" from the *10%......using "" converts it to text

[Karnik]

Hi FDibbins,
Thanks once again rescuing me!
Cheers
Karnik

[Karnik]

Hi FDibbins,

I am back!
Some exceptions to data in function suggested by you is as follows:

F(E2=0,"",IF((E2-D2)/D2>=20%,20%,""))

This works well if value in E2=0 BUT if E2 has some amount and D2=0, it givens #Div/0!. For majority data in column D has>1 so it works; large amount column D=0, it results #Div/0!

Attempted few permutation& combination using IF/OR....but no solution; I currently use filter and change manually

I am back too square one!

Please guide,

Thanks
Karnik

[Glenn Kennedy]

If you're dividing by zero Excel will give you that error message. if you want it to be blank then use this:

=iferror(iF(E2=0,"",IF((E2-D2)/D2>=20%,20%,"")),"")

If that's not what you want, please explain what you DO want.

[Karnik]

Hi Glenn,
Thanks, in the past you have helped me.
Thanks for enlightening iserr and iserror difference here!

Cheers
Karnik

[Glenn Kennedy]

Yes, I remember your "Name". glad to have helped.

[FDibbins]

Happy to help and thanks for the rep.

Glenn, thanks for the assist