Hi, i am auto summing on a range of cells. soome of the cells do not have figures in yet but do have formulas that return #NA at the moment. How do I ignore...

Does anybody know why I am getting #NA with this formula. It was working OK awhile...

I have the following formula that I am having a problem with. =IF(R589=FALSE,G589,VLOOKUP(M589,Feature_Average,4,)) basically I am looking for a value in a...

In XL2K I have a range of cells linked to a password protected workbook I did it using Paste Special Paste Link with both files open I close and save both...

Since changing to office 2007 all of the Hyperion Retrieve spreadsheets that are e-mailed to me, all retrieve formulas turn to #NAME errors. How do I fix...

I am dividing two cells. Sometimes there is a "0" in the denominator and it gives me the error message. I tried writing an "if" statement but have not been...

While retriving data from a plugin. Instead of calculated values #Name appears in all cells. Thanks for the help

I have a column linked to some website. The number can be shown in Excel 2003, but when I open this file in Excel 2007, there are only #NAME shown in the...

I got the "#NAME" result when I attempted to use the networkdays formula. The help file suggested the Analysis-TookPK be installed for this formula to work....

I have two separate workbooks on different network drives. One is a SHARED workbook and one is not. What I am doing is using a COUNTIF formual to bring...

I sent a spread to a co-worker that has some simple calculations. Some of the calculations are average and standard deviation of value from the same worksheet,...

I have a spreadsheet which has the formula =NETWORKDAYS(B2,D2)-1 and now when I try to fill information into the row the column with the formula (which...

I am importing a bank account statement to a workbook and everything is fine except for one of the lodgement accounts. the problem with this is that the name...

one of the main functions that I use excel for is creating dsadduser sheets for creating new activedirectory groups each semester with the change to excel...

hi all... I have been working with various functions in Excel. If any function fails to retrive the result, the cell displays #NAME? or #N/A. or something...

I am getting the above error for this formula and I can't figure out why. Any...

I have a formula that works in excel 07 version fine. I can change the cell amounts (I$2) that the "matches" are looking at it reads the formula fine. In...

Greetings, I have a formula that is looking at the contents of another cell and choosing one of three letters to display. It is giving me #NAME? error on the...

Hi All, I have a situation where I upgraded a computer from Win98 to WinXP and now Excel 2000 files using EDATE for amortization schedule generates...

My msnstockquotes function suddenly stopped working. I run Excel 2007. A worksheet I had created with numerous quote functions blew up a few days ago. When I...