pjfanning commented on pull request #256: URL: https://github.com/apache/poi/pull/256#issuecomment-931274259
I'm not sure if you are not misusing the POI npv call - in your excel, you have `=NPV(F15,B14:B16)+B13` - in POI, this is FinanceLib.npv(F15, B14:B16) + B13 - so only the last 3 numbers in the cell area `B13:B16` are passed to the NPV function (`B14:B16`) and then you add B13 separately If you use `=NPV(F15,B13:B16)`, you get 32891.7038768179 POI is a Java port of Excel and we have to match Excel, we do not want to match numpy - our users expect us to match Excel -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
