The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.
Hi
I'm trying to solve an issue where I want the if function to work, when one of the variables in some cases could be undefined.
Is this possible, or have some work around?
I'm using Prime 9.
I don't see a way.
Even the 'Try/On error' programming construct will not allow an undefined variable in the 'try' part.
Success!
Luc
As already Luc shows, at first fix the error in Prime sheet.
Then you can use your functions.