The PRICE formula is not producing expected results in the spreadsheet

The PRICE formula is not producing expected results in the spreadsheet

Posted by: qui.ha on 27 August 2025, 11:17 pm EST

• 

  qui.ha

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 August 2025, 11:17 pm EST - Updated 27 August 2025, 11:24 pm EST

  The output differs from what is generated in Desktop Excel and SpreadJS.
  
  Please refer to the attached snips and the sample Excel file used for comparison.
  
  

  

  1290×466 21.7 KB

  

  1358×508 33.9 KB

  File for PRICE formula.zip

• 

  qui.ha

  • Post Options:
  • Link
    Copy

  Posted 27 August 2025, 11:18 pm EST

  Please help to check

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 28 August 2025, 4:40 am EST

  Hi,

  Apologies for the inconvinience caused.

  We can replicate the issue you mentioned. We have escalated this issue to the concerned team and will update you as soon as we get any information from their end.

  Internal Tracking ID: SJS-31235

  Kind Regards,
  
  Chirag Gupta

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 16 September 2025, 5:27 am EST

  Hi Hà,

  The issue has been resolved in SpreadJS Version 18.2.2, the build for which can be downloaded from https://developer.mescius.com/spreadjs/download.

  Please let us know if you encounter any further issues or require additional assistance.

  Kind Regards,
  
  Chirag Gupta