IF function returns function statement rather than result

B

Bob Umlas

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 (~)
 
C

ckrogers

Thank you! That fixed it!

Bob Umlas said:
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 (~)
Click to expand...
 
Top