Removing Divide By Zero Errors within a Custom Formula Column

Platform discussions Special workflows & use cases
1

Hi, I’m a new Monday user and I was hoping to get some help on a custom formula column i have on a table.
For context, I am trying to display an average cost per lead for my Facebook Ads, I am using Supermetrics Campaign Reporting.

I have data in Total Spent Column.
I have data in Results Column.

I have a column i created which i have called 'Cost Per Result which is made by using the following formula:

“£” & TEXT({Total Spent (GBP)}/{Results}, “#,##0.00”)

Thanks to the members that have helped with the string to allow me to add the £ symbol.

Some of the Rows in my Results column have 0 so my Cost Per Results Column is displaying an error. Is there something i can do to my Cost Per Results formula that will make it display a 0 if 0 exists in the Result Column?

Hope that makes sense, I’m still learning!

2

Hey @ChrisC - you could try wrapping it in an IF statement:

IF({Results} > 0, “£” & TEXT({Total Spent (GBP)}/{Results}, “#,##0.00”), “”)

Thanks,
Mark

3

Unfortunately that hasn’t worked but i appreciate the response!

4

@ChrisC,

This should work for you:

IF(({Results} + 0) = 0, "",  "£" & TEXT({Total Spent (GBP)} / 
   IF(({Results} + 0) = 0, 1, {Results}), "#,##0.00"))

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday.com

5

That worked! thank you!