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!

IF Formula Not Working
 

check if the cell is not formated as text.

change it to general.

Also maybe is a typo error but your formula needs a "(quote) after IN

=if(h2<0,"CM","IN")

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"novice" escreveu:

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!

IF Formula Not Working
 

Your cell was formatted as text before entering the formula.
Format as general AND re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"novice" wrote in message ...
| 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!

IF Formula Not Working
 

Sounds like the cell is formatted as TEXT. Change the format to GENERAL.
Then, with the cell still selected press function key F2 then hit ENTER.

--
Biff
Microsoft Excel MVP


"novice" wrote in message
...
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!

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