Fritz Paul
asked on
How can cells with formulas "=#N/A" have values?
In the attached workbook. Sheet=Master. In rows 96 to 108 Column E and Column G has formulas "=#N/A" in them. They display values. Can you explain that please?
Strange1.xlsx
Strange1.xlsx
Looks like they need to be recalculated. If you go into each cell, press F2 and then enter, the displayed value changes to #N/A.
However, pressing F9 doesn't appear to do anything.
However, pressing F9 doesn't appear to do anything.
Make sure that you have Automatic calculations set on in the Formulas Tab/Calculation Options section.
I find it sometimes makes a difference by formatting.
Suppose you want to add some numbers in the a column, but want to show the results in B1
In the B1 field, you type "=SUM(A1:A10)", and the A cells are formatted differently than the B cells, you may get this error.
Suppose you want to add some numbers in the a column, but want to show the results in B1
In the B1 field, you type "=SUM(A1:A10)", and the A cells are formatted differently than the B cells, you may get this error.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I believe you are right.
Thanks.
Thanks.
HTH,
Dan