Excel won't calculate my formulas correctly.

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas in a cell 2
Excel functions 0
Scrabble Value calculation for Welsh words 0
Help Creating Excel Formula 4
Two functions in one formula. 1
Creating a formula relating to several cells 2
Error with sum formula in excel 2007 4
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 1

Top