Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How create blank cell value as the result of Excel "IF" function? | Excel Worksheet Functions | |||
Finding cell that returns bad "solver_val" function. | Excel Discussion (Misc queries) | |||
Why MS Excel produce diffrent result for the function "Quartile" | Excel Worksheet Functions | |||
SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx | Excel Worksheet Functions | |||
Excel "mode" function returns different results based on sort orde | Excel Worksheet Functions |