IF Formula Not Working

  • Thread starter Thread starter novice
  • Start date Start date
N

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!
 
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:
 
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!
 
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.
 
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
 
Back
Top