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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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
|
|||
|
|||
"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
|
|||
|
|||
"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
|
|||
|
|||
"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
|
|||
|
|||
"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
|
|||
|
|||
"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
|
|||
|
|||
"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 | |
|
|