I am trying to assign a valid Excel formula =IF(((I2/H2)>0.25)|I2/H2|"") that calculates a ratio between 2 cells and only displays the result if the ratio is greater than 0.25 otherwise the cell is assigned “” (display nothing).
I get an Aspose Cells exception. I’ve tried variations including assigning the Formula to a String variable, same results.
Aspose.Cells.CellsException: ‘Invalid ‘"’(Based on cell CSC!J2)’
image.png (122.8 KB)