formula not working

Mar 8th, 2002, 12:58 PM

For some reason my formula do work
eg. after I type in =if(..,..,..) and enter
the cell just show what I have typed in
=if(..,..,..)
Why does it do that?

Mark W. · Mar 8th, 2002, 12:59 PM

The cell is formatted as Text. Change its format to General.

Barrie Davidson · Mar 8th, 2002, 12:59 PM

Quote:

On 2002-03-08 11:58, Anonymous wrote:
For some reason my formula do work
eg. after I type in =if(..,..,..) and enter
the cell just show what I have typed in
=if(..,..,..)
Why does it do that?

Is your cell formatted as text?

Mar 8th, 2002, 01:06 PM

oh yes, it works
Thanks guys

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 12:58 PM	#1
Guest Posts: n/a	For some reason my formula do work eg. after I type in =if(..,..,..) and enter the cell just show what I have typed in =if(..,..,..) Why does it do that?

Mar 8th, 2002, 12:59 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	The cell is formatted as Text. Change its format to General.

Mar 8th, 2002, 01:06 PM	#4
Guest Posts: n/a	oh yes, it works Thanks guys