| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cells displays formula, not results
I have a formula that looks at a cell named "Customer" and if the cell is not
blank, it copies the contents of Customer. Here is the formula: =IF(Customer="","",Customer) . The cell will only display the formula, not the results. I use the exact same formula all over the rest of the page, and they all display fine. All my cells are also formatted the same. Anyone know what the problem is? |
|
#2
|
|||
|
|||
|
The most common cause of this is that the cell was pre-formatted as Text.
Format that cell as General then F2 and <ENTER Gord Dibben Excel MVP On Wed, 19 Jan 2005 13:17:13 -0800, synaptic5150 wrote: I have a formula that looks at a cell named "Customer" and if the cell is not blank, it copies the contents of Customer. Here is the formula: =IF(Customer="","",Customer) . The cell will only display the formula, not the results. I use the exact same formula all over the rest of the page, and they all display fine. All my cells are also formatted the same. Anyone know what the problem is? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| Formula displays does not calculate | Excel Discussion (Misc queries) | |||
| Excell only displays the formula, not the results | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Linear Mode
