| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula will not calculate
I have a workbook that is not shared or protected, and the formulas I enter
do not calculate. If I enter =C2=B2 it displays the formula as typed instead of calculating. There is no apostrophe before the "=" sign either. What's the issue? How can I get my formulas to work? Thanks. EU |
|
#2
|
|||
|
|||
|
Never mind. The format of the cell was set to "Text". I reset it to "General"
and now the cell will allow the formula to calculate. Thanks. "Excel User" wrote: I have a workbook that is not shared or protected, and the formulas I enter do not calculate. If I enter =C2=B2 it displays the formula as typed instead of calculating. There is no apostrophe before the "=" sign either. What's the issue? How can I get my formulas to work? Thanks. EU |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
| Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
| Formula displays does not calculate | Excel Discussion (Misc queries) | |||
| X IN A CELL TO CALCULATE A FORMULA | Excel Worksheet Functions | |||
| Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions | |||
Linear Mode
