Improvements on IF() and IFNA() functions

Version: 2019b

Type: Features

Category: Programming

Subcategory: Labtalk

Jira: ORG-19433

  • Fixed if(C=0,A,"") and C==0? A:"" issue of only filling 1st occurance of true condition.
  • Default else to blank. E.g. fill column A with 1, 2, 3 and enter if(A=2,100) in column B's F(X), row 1 and 3 should be blank values instead of missing.
  • IF() supports both numeric and string return. E.g. if(A<5,"small","big") works. In 2019, user needs to type if(A<5,"small","big")$