Cells displays formula, not results

S

synaptic5150

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Sum in Excel 1
Copy the content of a cell with Formula 1
formula displays as a formula, not as its result 1
Combing a V Lookup result with ("00"&A2)*1 in same formula 4
E2007 formulas display as formulas, not results 3
Counting Results of Formulas 1
Need a proper guru! My head hurts ;( 1
Formula results display only after pressing Enter key 1

Top