Puts formula in cell instead of result


  1. Posts : 166
    microsoft windows 10
       #1

    Puts formula in cell instead of result


    Hi all,,,, I don't know what is wrong with my spreadsheet but I put VLOOKUP(E17,B1:C16,2,1) into the cell E20 and instead of putting the result in E20 it puts the formula.
    I have treble checked and the data is correct and the cells formatting are correct, can someone help please,
    it has occoured elsewhere too, and I wonder if it has anything to do with me deleting cols and then replacing them,
    Len
      My Computer

  2. z3r010's Avatar
    Posts : 9,900
    Windows 10 Workstation x64
       #2

    Did you put = before the formula?
      My Computers

  3. Berton's Avatar
    Posts : 10,493
    Win10 Pro Versions 2004 and 2009/20H2, Win10 Pro IP_Dev, Win10 Home 1909
       #3

    z3r010 said:
    Did you put = before the formula?
    Yep, works that way with my Excel 2000 on Win10.
      My Computers


  4. Posts : 166
    microsoft windows 10
    Thread Starter
       #4

    Yes I did put the =
    Len
      My Computer

  5. Bree's Avatar
    Posts : 18,617
    10 Home x64 (20H2) (10 Pro on 2nd pc)
       #5

    donnylad said:
    ...instead of putting the result in E20 it puts the formula.
    There's an Excel display option in 'Advanced' that will do that, check your settings.

    Puts formula in cell instead of result-image.png
      My Computers

  6. meebers's Avatar
    Posts : 1,286
    W10 20H2 .685 & W10 Insider
       #6

    Sometime when a cell does not produce the correct solution with a formula, there may be a hidden entry/format there that would mess with it. Right click the cell and choose "clear contents" then try the formula again. Is this the only cell doing this, or are others showing the same problem??
      My Computers


  7. Posts : 166
    microsoft windows 10
    Thread Starter
       #7

    I looked in advanced and it is already switched off, also other cells are doing the same thing.
    Len
      My Computer


  8. Posts : 1,954
    Windows 10
       #8

    You have formatted the Cell(s) as text. Delete the contents and change format to General and enter again.

    Or change the Cell to general format and re-enter from the formula bar.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 11:20.
Find Us




Windows 10 Forums