PRICE() comes with Analysis Toolpack
in Excel 2003 go to Tools-Options-Add-Ins-install this add-in


On 7 Maj, 06:05, Leo wrote:
I keep getting a #REF! error with the PRICE() fomula in my spreadsheet, even
I copy and paste the expamle in the excel help.
but if I paste the expamle in another blank XL workbook, the formula works
fine, and gives the correct result.
I evaluate the fomula step by step, it PRICE(....) changed to REF(....) at
the first step. So it seems the spreadsheet do not recognize the fomula.
Anyone can help it pls, many thanks