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 statement rather than result
Hi. I have a simple "IF" statement in my Excel workbook
|
#2
|
|||
|
|||
IF function returns function statement rather than result
You're either entering it in a cell formatted as Text or you're looking at
the formula layer instead of the value layer. If the former, redefine the format of the cell as General (or whatever you want) and re-enter the formula. If the latter, press ctrl/tilde (~) "ckrogers" wrote in message ... Hi. I have a simple "IF" statement in my Excel workbook |
#3
|
|||
|
|||
IF function returns function statement rather than result
Tools Options View uncheck Formulas
"ckrogers" wrote: Hi. I have a simple "IF" statement in my Excel workbook |
#4
|
|||
|
|||
IF function returns function statement rather than result
Thank you! That fixed it!
"Bob Umlas" wrote: You're either entering it in a cell formatted as Text or you're looking at the formula layer instead of the value layer. If the former, redefine the format of the cell as General (or whatever you want) and re-enter the formula. If the latter, press ctrl/tilde (~) "ckrogers" wrote in message ... Hi. I have a simple "IF" statement in my Excel workbook |
Thread Tools | |
Display Modes | |
|
|