IF function returns function statement rather than result

  • Thread starter Thread starter ckrogers
  • Start date Start date
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 (~)
 
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...
 
Back
Top