Posted to microsoft.public.excel.worksheet.functions

Dave Peterson Dave Peterson is offline

external usenet poster

Posts: 35,218

IF Formula Not Working

And if you see the formula in each cell, maybe you're looking at formulas:

Tools|Options|view tab|Uncheck formulas

ctrl-`
control-backquote (near the 1/! on my USA keyboard) is the shortcut key

novice wrote:

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!

--

Dave Peterson

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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 01:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us