If functions when one of the variables are undefined

[TA_10206400]

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.

[LucMeekes]

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

[ttokoro]

As already Luc shows, at first fix the error in Prime sheet.

Then you can use your functions.