Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
got #REF! with fomula PRICE()
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
got #REF! with fomula PRICE()
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
got #REF! with fomula PRICE()
thank JK,
maybe i did not make it clear. it's quite wierd actuall... to be honest i got the toolpack installed. actually i exam the fumula in a new workbook in the exact same excel window...the Price() fumula works, but in my spreadsheet it doesn't, and keep giving back the #REF! result. that's all of the syndrom...anyone can kindly help to figure out what could be the possible causes to the error. many thanks leo "Jarek Kujawa" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
Price List overall price increase | Excel Discussion (Misc queries) | |||
base price list compute on to another price list? on excel work sh | Excel Discussion (Misc queries) | |||
calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) |