Watch

Welcome to the JavaScript feedback portal. We’re happy you’re here! If you have feedback on how to improve the JavaScript, we’d love to hear it!

Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

Vote

Need to fix the nested IF formula issue in spreadsheet Completed

: May 20, 2021 12:10 PM

: Jun 09, 2021 7:03 AM

: Bug Report

: Spreadsheet

: 19.1.0.59

: Vol 2 2021 (Jun 30, 2021)

: May 20, 2021 12:10 PM

: Bug Report

: Spreadsheet

Need to fix the nested IF formula issue in spreadsheet. The formula values not parsed properly for the nested formulas (=IF(A1="","None",IF(A1>10,"Pass","Fail"), =IF(SUMIF(A1:A6,"<0",B1:B6)<0,1,2)). Need to ensure all dependent cases for the same related formulas

Expected Result for 1^st Formula

Actual result for 1^st Formula

Actual Result for 2^nd Formula

Expected result for 2^nd Formula

1 COMMENT