two results from IF statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I recently inserted an IF statement that the result in the function Arguments
Box is correct and as expected for the IF statement. The result on screen
is, =IF(S16="X",'Combination Sheet'!K22,""), a text version of the function
argument. I have changed formatting of cells a number of times. It looks
like it lost the ability to calculate, although there are multiple if,
volookup statements in the spreadsheet.
 
Your formula was originally entered while the cell was formatted as text.
Subsequently changing the format will not cause it to correct itself until
you re-enter the formula. All that really requires is that you select the
cell, press the F2 key, then press the Enter key
 
Thanks for your input it works easily

Duke Carey said:
Your formula was originally entered while the cell was formatted as text.
Subsequently changing the format will not cause it to correct itself until
you re-enter the formula. All that really requires is that you select the
cell, press the F2 key, then press the Enter key
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

adding result of "if" statement.. 3
Logical test in IF statement returning incorrect result 3
result given from content of selected cells. 5
MATCH not working in IF statement 6
Creating a dynamic IF statement 2
Using Formulae in If statements 8
"IF" function returns function instead of result 6
If statements resulting in formatting of cells 3

Back
Top