Why does the SUM function in B7 show zero?
Why could the formulas in C3 and C4 cause #VALUE! errors?
Why doesn't the SUM formula in E10 show an answer of $30,000?
Cell B10 is being edited. B8 contains the formula =SUBTOTAL(9,B4:B7). What number will appear in B10 once the user presses Enter?
What does the word "Calculate" indicate when displayed in the status bar?
What's wrong with the function in B7 below?
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?
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.
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"))
Each green cell contains exactly the same formula (ie =CellAbove ). How come each one displays a different result?