Formula is malfunctioning

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Hi,

Does anyone know why sometimes formulas don't actually
execute - they just show the formula in the cell.

i.e. =SUM(B2:B33)will be in the box verse it actually
giving you the answer. This has happen to me with other
formulas i.e. VLookups!

Do you think it is a BUG!

Thanks, Bonnie
 
Hi
probably the cell is formated as 'Text'. goto 'Cells - Format' and
change the format to 'General'. After this re-enter your formula
 
Do you think it is a BUG!

Nope. More likely the cell was formatted as Text when you entered the
formula. XL's parser doesn't evaluate entries in Text-formatted cells.
 
That Worked!

As I have been using this newsgroup recently! I can Say
you are AWESOME with answers!

Are you with Microsoft in Germany!

Thanks B.
 
Back
Top