# Error with IF formula

Hello.

I have a table with 5 columns : A, B, C are columns with values, whereas D and E are formulas.
D formula is
{B}+{C}
and E formula is :
IF(({A} = 0), 0, ({D}/{A}))

What I dont understand is when A equals 0, the E column returns an error “Impossible to divide by 0”. Shouldn’t it print 0 ? Why is it still trying to do D / A ?

@PierreM

The answer is in one of the monday formulas videos I did… Don’t remember which one.

The short answer is to use one of these:

``````IF(({A} = 0), 0, DIVIDE({D}, {A}))
``````

OR

``````IF(({A} = 0), 0, ({D}/IF({A}=0, 1, {A})))
``````

Jim - The Monday Man - YouTube Channel
Watch Our Latest Video: monday.com Mirror Columns in Integromat - the Basics

Check out our monday apps, now in beta: The Monday Man Apps

1 Like

Thanks for the help @JCorrell , my problem is solved. This a bit strange to evaluate everything in the formula but at least I’m aware of this now.
I think you were talking about this video btw

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.