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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Incone & Expenses Statement 0
Multiple arguments 3
"IF" function returns function instead of result 6
Re-title multiple MS Project .mpp files at once 0
Excel - Wich Function should I use? 1
wdActiveEndSectionNumber 1
Use TODAY() function as the criteria in a SUMIF formula 1

Top