"IF" function returns function instead of result

  • Thread starter Thread starter ckrogers
  • Start date Start date
C

ckrogers

Hi. I have a simple '=IF(K7="LF",L7," ")' function in my workbook to display
the value in cell L7 if the Logical Test is "TRUE", otherwise leave the cell
blank. When I'm building the function and insert the arguments, it shows me
the correct result ... but when I hit "OK" to insert the function, it
displays the actual function rather than the result. Why?
Thanks for any help.
Cindy
 
Cindy,

Goto Tools > Options > Uncheck "Formulas" in the Window options section > OK

Hopes this helps.
 
or press CTRL+` to switch/achieve the same


U¿ytkownik "Per Jessen said:
Cindy,

Goto Tools > Options > Uncheck "Formulas" in the Window options section >
OK

Hopes this helps.
Click to expand...
 
Unfortunately, that box isn't checked ... and I have many other formulas in
my workbook that are working correctly. Any other suggestions? Is it
possible I have TOO MANY formulas in the workbook?
 
Someone else suggested that my cell was formatted as Text and should be
General. I changed it as suggested and that fixed my problem.

Thank you all!
Cindy
 
Try to format cell as GENERAL instead of TEXT

ckrogers said:
Unfortunately, that box isn't checked ... and I have many other formulas in
my workbook that are working correctly. Any other suggestions? Is it
possible I have TOO MANY formulas in the workbook?
Click to expand...
 
hope you don't put an aporstrophe before the = sign?

like you did in OP: '=IF(K7="LF",L7," ")'
 
Back
Top