#Error throwing off calculation

[canberry]

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

 

[SQL_Hell]

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

 

[Dennisk]

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

 

[canberry]

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 ?

 

[Atomic Shrimp]

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.

 

[DCrake]

Try

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

 

[Atomic Shrimp]

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.

 

[canberry]

Good to go.Thanks alot