Odd Excel Formula Problem
I am building a spreadsheet tool that pulls data from either another sheet or
another workbook. In both cases, when I write my formulas, the seem to work initially, but at some point something happens and instead of displaying the result of the formula, they display the formula as text. For example: In Cell A1 I type =if($A$2=$A$3,1,0) initially it display's my desired result ("0"). Then, if I go in and try to unlock the cells to copy down and across the formula result changes to "=if($A$2=$A$3,1,0)" I have never seen this error and can't figure out why it's happening. I tried reformatting and settings and those don't seem to be the problem. Any thoughts? |
Odd Excel Formula Problem
After reformatting the cells as General you should open each for editing.
Or Delete the text, format the cells and recopy the formulas best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "Questions" wrote in message ... I am building a spreadsheet tool that pulls data from either another sheet or another workbook. In both cases, when I write my formulas, the seem to work initially, but at some point something happens and instead of displaying the result of the formula, they display the formula as text. For example: In Cell A1 I type =if($A$2=$A$3,1,0) initially it display's my desired result ("0"). Then, if I go in and try to unlock the cells to copy down and across the formula result changes to "=if($A$2=$A$3,1,0)" I have never seen this error and can't figure out why it's happening. I tried reformatting and settings and those don't seem to be the problem. Any thoughts? |
All times are GMT +1. The time now is 02:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com