| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas appearing as text instead of computing
We recently changed all of our computers and I am apparently struggling with
new settings. In Excel, I am entering formulas such as =if(Q5=Q4,x,""). In the cell, it is showing up as entered instead of an "x", "", or some sort of error. To further test it, I entered =1+1 into a cell and I did not get 2, but "=1+1" is visible in the cell. What setting needs to be fixed? TIA Papa |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL | Excel Discussion (Misc queries) | |||
| Text not appearing as typed in Excel | Excel Discussion (Misc queries) | |||
| Full Text is not appearing in column | Excel Discussion (Misc queries) | |||
| SOS - My formulas aren't computing down my rows but copying same | Excel Worksheet Functions | |||
| Why is my cell text not appearing? | Excel Discussion (Misc queries) | |||
Threaded Mode
