Posted to microsoft.public.excel.worksheet.functions

Novice

external usenet poster

Posts: 52

IF Formula Not Working

Hi,

When I use the IF formula in excel e.g. =if(h2<0,"CM","IN)
it displays the formula, not result (CM or IN)

Anyone knows why?

Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Not Working	JBoyer	Excel Worksheet Functions	3	July 27th 08 08:07 AM
IF Formula not working	holyman	Excel Discussion (Misc queries)	12	August 30th 07 08:06 PM
Formula not working	joesf16	Excel Worksheet Functions	2	May 21st 07 04:17 AM
Formula not working for me now	S S	Excel Worksheet Functions	2	July 16th 06 09:10 AM
Formula is not working	jesmin	Excel Discussion (Misc queries)	2	December 10th 05 03:19 PM

All times are GMT +1. The time now is 02:44 AM.

About Us

"It's about Microsoft Excel"