x-spreadsheet icon indicating copy to clipboard operation
x-spreadsheet copied to clipboard

Published 20 hours ago • verified publisher icon myliang

[BUG] IF formula issues

Open devgeni opened this issue 3 years ago • 0 comments

There are certain issues with using =IF() inside a cell.

  1. IF doesn't work with string equality:
  • Cell B3 has text Hello;
  • Any cell with content =IF(B3="Hello","OK","Fail") will output Fail instead of OK.
  1. IF can't be nested:
  • Assume cell B3 has 10;
  • Any cell with content =IF(B3=1,"OK",IF(B3=10,"OK","Fail")) will output true instead of OK.
  • Any cell with content =IF(B3=1,"OK",IF(B3=5,"OK",IF(B3=10,"OK","Fail"))) will crash the application.

devgeni avatar Mar 24 '22 15:03 devgeni