Iferror formula

tomflahavan
tomflahavan
in Modeling

Hi, 

 

I'm trying to do a calculation similar to the IFERROR calculation in excel but I can only seem to do the IFTHEN formula in Anaplan. Does anyone have a suggestion for this?

 

The excel function is IFERROR(X/Y, 0)

 

Thanks,

Tom

Tagged:

Best Answer

  • GeorgeDuckett
    GeorgeDuckett
    Answer ✓
    If it's a divide by zero error you're trying to handle you could just do IF Y = 0 THEN 0 ELSE X/Y

Answers

  • anirudh
    anirudh
    Can you give an example of an error that you are trying to catch

Categories