| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What causes = not to work?
On several occasions lately I've had the misfortune of my spreadsheet
refusing to treat a formula as a formula. Instead it shows me the formula. i.e. "=A2+A4" instead of "16". What causes this??? How do I avoid it? Also, when the formula does work, I'm having an issue when I drag the formula to other cells that it doesn't process unless I manually go into that cell and hit enter. The formula reads correctly, but the result is the same that was in the first cell until I click in the cell and hit enter. (This is not a relative/absolute reference issue) If these ring a bell to anyone...please help!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
| extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
Threaded Mode
