IF Formula Not Working

[novice]

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!

 

[Marcelo]

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:

 

[Niek Otten]

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

| 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!

 

[T. Valko]

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.

 

[Dave Peterson]

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