IF function returns function statement rather than result
 

Hi. I have a simple "IF" statement in my Excel workbook

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

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

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