Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel assignment
I have an excel assignment for a class and in the instructions it says, Only
in the input section will numbers show in the cell listing (formula display); every other cell will contain a formula. Can someone explain this to me in simple terms because i am new to the program and do not understand it. Thanks |
#2
|
|||
|
|||
Must admit it doesn't make perfect sense to me either. But let's give it a
try. Excel works like this: A cell can contain either a constant (a number, a date, a text) or a formula. In a blank sheet, enter a number in cell A1. In cell B1 enter =A1 You will now see the same number in both cells. Click cell A1 and you see the number in the formula bar above the sheet (if you don'št have it, choose it in the Viev menu). Click cell B1 and you see the formula in the formula bar, not the number. This formula says "pull to me whatever A1 contains at any time" so that's why they appear identical. Now go menu Tools Options , View pane and select "Formula". Now B1 displays not the cell result, but its real content, the formula. This may be what "formula display" is about. If so: "Formula display" is rarely used in daily life, most for auditing if so. The basic thing here is to know that a cell contains either a constant or a formula, never both. Type a number i B1 and the formula goes. HTH. Best wishes Harald "Davko" skrev i melding ... I have an excel assignment for a class and in the instructions it says, Only in the input section will numbers show in the cell listing (formula display); every other cell will contain a formula. Can someone explain this to me in simple terms because i am new to the program and do not understand it. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
html to excel | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
Shortcut file fails to open | Excel Discussion (Misc queries) |