Each green cell contains exactly the same formula (ie =CellAbove ). How come each one displays a different result?
The following formula should show "Fair", "Good" or "Excellent" depending on the value of A1 but there is an error in the logic. What value produces an incorrect result?
=IF(A1<500,"Fair",IF(AND(A1>500,A1<1500),"Good","Excellent"))
The range name "EmployeeLookupTbl" has been correctly defined to refer to the shaded area. What needs to be fixed in B5 and B6 so the functions show Pierre Francois' information rather than Graeme Smith's.
Why does the SUM function in B7 show zero?
I have a spreadsheet with many rows and columns of data as shown below. Yet when I print the entire sheet, only the highlighted range is printed. Why?
What's wrong with the function in B7 below?
What does the word "Calculate" indicate when displayed in the status bar?
Cell B10 is being edited. B8 contains the formula =SUBTOTAL(9,B4:B7). What number will appear in B10 once the user presses Enter?
Why doesn't the SUM formula in E10 show an answer of $30,000?
Why could the formulas in C3 and C4 cause #VALUE! errors?