If functions when one of the variables are undefined

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.

Skjermbilde 2023-04-28 kl. 22.39.15.png

23-Emerald IV

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

21-Topaz I

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

Then you can use your functions.

t.t.

Sign up