Formula Function Dividing by ZERO giving Exclamation Value

Feature requests
1

I am trying to do an IF statement that generates a Zero Value when dividing Col A by Col B, when Col A and B are already Zero Value. So 0/0 gives me a red exclamation mark saying “One of the parameters is invalid”. I want a formula to well give me Zero “0” as a value and not the exclamation mark. Usually in excel this is a simple IFISERROR function but I can,t figure this out.

Here is my formula when Item A, Item B and Price are “0”

({Item A}+{Item Bt})/{Price} = Exclamation Red Mark

Please help! Thanks

2

@Amanah

Untested, but correct answer:

IF({Price}<>0, DIVIDE({Item A} + {Item Bt}, {Price}), 0)

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in monday.com Formulas? YES!!!

1 Like
3

WOW - It worked. All I had to do was populate those empty fields with zero values and then the formula worked! No More annoying red exclamation marks. Thanks!!!

4

@Amanah

Well, that won’t due. Let’s fix that…

IF(({Price}+0) <> 0, DIVIDE({Item A} + {Item Bt}, {Price}), 0)

Now you won’t have to put the zeros in.

5

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