[BUG] IF formula issues

[devgeni]

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.

2. 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.