IFERROR function

Hi, is there any equivalent of the excel function IFERROR or a way of easily replicating it, please?

Hey Ian, in Causal you can use if-statements to check for the cause of the error. For example if you have a variable for the Profit Margin with the formula “Income / Revenue” you will get an error if the Revenue is 0. So to make sure you are not dividing by 0 you can use a formula like this:

iferror is a quick & handy way of handling exceptions in sheets/excel, without needing to build if/else statements for a potentially complex formula. It would be good to have something similar in causal

1 Like