View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Otero Tim Otero is offline
external usenet poster
 
Posts: 20
Default 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?