| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Mike--
Thanks so much! Shelie "Michael R Middleton" wrote: Shelie - Tools | Options | Calculation | Automatic, or press F9. - Mike www.mikemiddleton.com "Shelfish" wrote in message ... I just downloaded Crystal Ball to use with Excel, so that may be part of my problem. When I copy formulas, Excel won't calculate them correctly. Even if the formula is correct, the value is the same value as the original cell I copied the formula from. So, my initial cell will be "=A1*100". The value of A1 is 0.1. The answer is 10, which is correct. BUT, If I copy the formula down the column, the cells will correctly read "=A2*100", "=A3*100" etc., but all of the values will read "10", regardless of what the values in A2 & A3 are. Is it a settings problem or something? If you have any ideas, I would greatly appreciate it. Thanks!! Shelie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| Suddenly cannot calculate functions or formulas in Excel | Excel Worksheet Functions | |||
| How do I hide formulas in Excel cells? | Excel Discussion (Misc queries) | |||
| How do I get to master Excel functions and formulas? | Excel Worksheet Functions | |||
| Calculate date of birth in Excel | Excel Worksheet Functions | |||
Hybrid Mode
