Puts formula in cell instead of result


  1. Posts : 170
    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. Posts : 10,523
    Windows 10 Workstation x64
       #2

    Did you put = before the formula?
      My Computers


  3. Posts : 12,417
    Win10 Version 21H2 Pro and Home, Win11 Pro
       #3

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


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

    Yes I did put the =
    Len
      My Computer


  5. Posts : 24,545
    10 Home x64 (21H2) (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. Posts : 1,375
    W10 21H2 19044.1387
       #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 : 170
    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 : 2,277
    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 23:11.
Find Us




Windows 10 Forums