Simple excel formula

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

Guest

I have two excel workbooks. There is data in one workbook and the second
workbook contains a = to a cell in the first work book. Most of the formulas
are working, except the 1st and the last two instead of giving me the result
it is showing the formula. When I do a formula audit the only difference i
see between the working formula and the non working formula is the non
working formula contains a constant. Why would this make a difference and
how do I fix this?
 
I changed this from text to general several times but this did not fix it but
when I added F2 enter to the end the results showed
WHY?
What does F2 enter do?
 
Back
Top