Error with IF formula


I have a table with 5 columns : A, B, C are columns with values, whereas D and E are formulas.
D formula is
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. :grin:

The short answer is to use one of these:

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


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

Jim - The Monday Man - YouTube Channel
Watch Our Latest Video: 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 :smile:

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