Get different results from Excel vs LibreOffice Calc
I am getting different results from Excel vs LibreOffice Calc for a spreadsheet that uses the PERCENTRANK function to classify stock valuations. After calculating several different category valuations, they are multiplied together to calculate a multifactor value which is then filtered and sorted. For some reason I am getting different results on the category valuations when using Excel versus Calc. I’m not sure which one is more correct. Attached is the spreadsheet (with the blank multifactor deleted to reduce file size below 10MB).
Any ideas of what could cause this?
|Trending Value Stock Selector 02-11-2013 cut blank mf rows.xls||2.82 MB|