A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"IF" function returns function instead of result



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2009, 08:55 PM posted to microsoft.public.excel.worksheet.functions
ckrogers
external usenet poster
 
Posts: 14
Default "IF" function returns function instead of result

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
  #2  
Old April 16th, 2009, 09:01 PM posted to microsoft.public.excel.worksheet.functions
Per Jessen
external usenet poster
 
Posts: 686
Default "IF" function returns function instead of result

Cindy,

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

Hopes this helps.

---
Per

"ckrogers" skrev i meddelelsen
...
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


  #3  
Old April 16th, 2009, 09:09 PM posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_3_]
external usenet poster
 
Posts: 29
Default "IF" function returns function instead of result

or press CTRL+` to switch/achieve the same


Użytkownik "Per Jessen" napisał w wiadomości
...
Cindy,

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

Hopes this helps.

---
Per

"ckrogers" skrev i meddelelsen
...
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




  #4  
Old April 16th, 2009, 09:18 PM posted to microsoft.public.excel.worksheet.functions
ckrogers
external usenet poster
 
Posts: 14
Default "IF" function returns function instead of result

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?

"Per Jessen" wrote:

Cindy,

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

Hopes this helps.

---
Per

"ckrogers" skrev i meddelelsen
...
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



  #5  
Old April 16th, 2009, 09:23 PM posted to microsoft.public.excel.worksheet.functions
ckrogers
external usenet poster
 
Posts: 14
Default "IF" function returns function instead of result

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

"ckrogers" wrote:

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?

"Per Jessen" wrote:

Cindy,

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

Hopes this helps.

---
Per

"ckrogers" skrev i meddelelsen
...
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



  #6  
Old April 16th, 2009, 09:23 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
 
Posts: 3,722
Default "IF" function returns function instead of result

Try to format cell as GENERAL instead of TEXT

"ckrogers" wrote:

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?

"Per Jessen" wrote:

Cindy,

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

Hopes this helps.

---
Per

"ckrogers" skrev i meddelelsen
...
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



  #7  
Old April 16th, 2009, 09:24 PM posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_3_]
external usenet poster
 
Posts: 29
Default "IF" function returns function instead of result

hope you don't put an aporstrophe before the = sign?

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


Użytkownik "ckrogers" napisał w
wiadomości ...
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?

"Per Jessen" wrote:

Cindy,

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

Hopes this helps.

---
Per

"ckrogers" skrev i meddelelsen
...
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





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright Š2004-2024 OfficeFrustration.
The comments are property of their posters.