OR Function does not evaluate second argument

Platform discussions monday dev
1

Hi,
The OR function is not evaluating the second argument when comparing the values of two or more columns:

IF(OR({Column A}=0,
{Column B}=0),0,
DIVIDE({Column A},{Column B})*100)

Would appreciate if you look into this scenario.

Thanks,

Julian M.

2

Hi Julian! :waving_hand: Welcome to the monday Community! Can you please share what you are trying to achieve with your formula?

I replicated your use case in my test account, but I’d like a little more clarity from you to point you in the right direction. With the formula you shared, this is what I understand:

  1. If “Column A” or “Column B” equals “0,” the Formula Column should return “0.”

  2. If “Column A” or “Column B” does not equal “0,” then divide “Column B” from “Column A” and multiply by 100.

With your current formula, the result will always be 0 as the system will always be dividing by 0:

image
image447×179 2.71 KB

Please let me know if I can help explain the logic behind IF functions as well!

3

Hi Shannon Thao,

Attaching another email thread containing the detailed issue.

Let me know if you have additional questions and if you were able to see the pictures attached in the email.

Thanks,

(attachments)

~WRD037.jpg
~WRD037.jpg100×100 357 Bytes

image001.gif
image004.png
image005.jpg
image005.jpg393×117 7.43 KB

image006.jpg
image006.jpg657×184 14.5 KB

4

Hi Mia,

The quick overview will be the following:

Division by zero is undefined in mathematics so it will be great if a function within Monday.com can be added when the denominator on a division is cero or the result of the used formula evaluates to an error. This way it will give users the choice to overwrite the outcome.

In my case, I just need to force the calculation to be cero when the denominator between two columns is cero.

Check excel’s solutions for this, IFERROR: https://support.microsoft.com/en-us/office/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611

There is a second solution: IFNA: https://support.microsoft.com/en-us/office/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461

Thanks,

5

Our automation app formula pro automations solves this exact issue. It has more functions than the native monday.com formula column and support for most excel functions.

You can use the IFERROR function in this way:

IFERROR(IF(AND({item's Column A}=0,
{item's Column B}=0),0,
DIVIDE({item's Column A},{item's Column B})*100), SKIP())

You can add it to your board and try it out using this link: Formula PRO Automations - monday.com Marketplace

Let me know if that helps.