formula returns formula
 

Sometimes when I enter a formula in a cell, even using
the formula wizard, the cell returns the formula instead
of the results. (The right results will show in the
formula wizard so I know it is right.) What am I doing
wrong? Is it a format problem?

formula returns formula
 

Mi Mark,

Use the INDIRECT function to display the results of the formula. Chip
Pearson has some good info on this:

http://www.cpearson.com/excel/indirect.htm

tim

"Mark Jeffcoat" wrote in message
...
Sometimes when I enter a formula in a cell, even using
the formula wizard, the cell returns the formula instead
of the results. (The right results will show in the
formula wizard so I know it is right.) What am I doing
wrong? Is it a format problem?