Hi all. I get a #Error even when my formula boils down to eg... ((A-B) + (C/D)) * .10
Where C and D = 0. A= 30, B=4
I really want the output to be 2.6

Tell me if i need to post my formula

If D is zero then that's your problem you cant divide by zero. Try it on a calculator...it's not possible

Division by zero C/D where D = 0 is the cause of your problem

Yea, i agree u cant divide 0/0. But that result added to a figure should return that figure. (0/0) + 8 = 8.

Does any 1 have any experience with the NullToZero function. I tried it in my query but it not working ?

You can't divide anything by zero - it's fundamentally impossible.

What real-world information is this formula representing? (because it sounds like it might not be doing so properly).

Null to zero won't help, as that converts to zero.

Try

((A-B) + iif(C>0 And D> 0,(C/D),0)) * .10

Try

((A-B) + iif(C>0 And D> 0,(C/D),0)) * .10

((A-B) + iif(D> 0,(C/D),0)) * .10 should work OK - because you can divide 0 by things, just not the other way around.

:D Good to go.Thanks alot