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 ?
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
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.