ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula will not calculate (https://www.excelbanter.com/excel-discussion-misc-queries/12544-formula-will-not-calculate.html)

Excel User

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

Excel User

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



All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com