Windows 10: Puts formula in cell instead of result

Discus and support Puts formula in cell instead of result in Microsoft Office and 365 to solve the problem; 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... Discussion in 'Microsoft Office and 365' started by donnylad, Nov 21, 2018.

  1. donnylad Win User

    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

    :)
     
    donnylad, Nov 21, 2018
    #1

  2. excel showing formulas not results

    a sheet that worked fine on windows phone 7 now shows ##### in the cell and the formula in the "formula box" not the result of the formula.

    anybody have any ideas.
     
    patricknortonc, Nov 21, 2018
    #2
  3. 구리 Win User
    Help~ No formula results( microsoft mathematics) .

    I put the following formula in microsoft mathematics.

    arcSin(sqrt(1/4-(tan(19.47))^2))

    or

    sin^-1(root(1/4 - (tan(19.47))^2 ))

    result : indeterminate

    Correct answer: 20.70627898 ( degree )
     
    구리, Nov 21, 2018
    #3
  4. Puts formula in cell instead of result

    mobile excel formula

    "Worksheet names—In a cell in a worksheet, Excel Mobile accurately displays names that reference worksheets within the same workbook. It removes names that refer to other workbooks, arrays such as ={1;2;3;4}, array formulas, or intersection ranges
    from the name list. When Excel Mobile removes a name from the list, it leaves the name in formulas and functions. This causes those formulas to be resolved as "#NAME?" Tabs that are hidden in the workbook are not hidden in Excel Mobile."

    http://www.microsoft.com/windowsmobile/en-us/help/more/excel-mobile.mspx

    You may want to investigate SoftMaker's PlanMaker:

    SoftMaker: Official Web Site

    Pocket PC Mauritius http://PocketpcMauritius.blogspot.com/ http://PPCMUDownloads.blogspot.com/
     
    Linley Meslier, Nov 21, 2018
    #4
Thema:

Puts formula in cell instead of result

Loading...
  1. Puts formula in cell instead of result - Similar Threads - Puts formula cell

  2. Free Cell

    in User Accounts and Family Safety
    Free Cell: Freecell keeps bringing up the same game with a different game number - about ten times, now. Makes it easy to solve, but dead boring. Any ideas? https://answers.microsoft.com/en-us/windows/forum/all/free-cell/123e3422-750e-4dc6-97b2-e3d87ae22400"
  3. average formula will not average

    in Windows 10 Network and Sharing
    average formula will not average: =IFERROR(AVERAGE(IF(C3:G3="","",IF(ISNUMBER(SEARCH("<",C3:G3)),SUBSTITUTE(C3:G3,"<","")/2,C3:G3))),"") Hello, Trying to use this formula to average three numbers in a row . However at end of row where I have average formula, I dont get an answer? When I click on...
  4. Creating a formula

    in Windows 10 Customization
    Creating a formula: I'm trying to create a formula to have one cell equal another cell if a third cell equals 1. Can anyone help? https://answers.microsoft.com/en-us/windows/forum/all/creating-a-formula/e79c89fe-2e2b-47cd-9dd6-ec5d8f1232fa
  5. Android cell

    in AntiVirus, Firewalls and System Security
    Android cell: Can I use windows defender to scan my android cell phone? https://answers.microsoft.com/en-us/protect/forum/all/android-cell/a47f8295-e1cc-4db4-9c07-a75e45ca18ba
  6. cant use the formula datedif in excel.

    in Windows 10 Installation and Upgrade
    cant use the formula datedif in excel.: macro in this excel file tried to execute unknown application. the action is blocked for security reason. https://answers.microsoft.com/en-us/windows/forum/all/cant-use-the-formula-datedif-in-excel/f771495a-e955-4b85-841a-59b76fa7df5a
  7. Need some help with a formula in WORKS

    in Microsoft Office and 365
    Need some help with a formula in WORKS: Hi Guys I need some help in setting up a formula for %. I want to do the following B2 minus A1 = D1 as a percentage Sorry, messed cells up, but basically want to buy/sell shares, show profit, and the % profit 114416
  8. Need some help with a formula in WORKS

    in Windows 10 Support
    Need some help with a formula in WORKS: Hi Guys I need some help in setting up a formula for %. I want to do the following B2 minus A1 = D1 as a percentage Sorry, messed cells up, but basically want to buy/sell shares, show profit, and the % profit 114416
  9. Notepad puts Y instead of \

    in Windows 10 Support
    Notepad puts Y instead of \: When I'm making a .bat file, the computer automatically puts some weird letter 'Y' as '\' but when I copy and paste the weird looking 'Y' lets say in this thread post it pastes as '\'. As some pictures are posted. [img] This is my Font Settings in Notepad: [img]...
  10. Search result - Move folders instead of file

    in Windows 10 Support
    Search result - Move folders instead of file: I have done a search for all files with the word e.g. "dvd" in the filename.. It returns a list of files result.. The problems is I want to move the folder/s that contains those files not just the file on it's own.. How can I do this? 72661