You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How to return an ERROR using functions

When a function doesn't have the data it needs, or is set up incorrectly, it returns an error icon (the red triangle with an exclamation mark). How do I intentionally return this error using functions?

I used to use IF statements to return an error by leaving the IFFALSE field blank. This worked for my needs until I built one that returned 0. I read that apparently if you leave IFFALSE or IFTRUE blank, it will correspondingly return 0 if those conditions are met.

Posted on Aug 31, 2022 10:55 PM

Reply
Question marked as Top-ranking reply

Posted on Aug 31, 2022 11:30 PM

Not sure what you are trying to do, but one simple way of introducing an error is to divide by 0.


SG

2 replies

How to return an ERROR using functions

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.