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. External reference formula produces different result when opened and closed...

    in Windows 10 Network and Sharing
    External reference formula produces different result when opened and closed...: Hi, i have two excel files A and B. File A has formula referenced to B. When file B is closed,file A's formula result shows incorrect result. When both file A and B are open,the formula result shows correct result. The result change instantaneously when file B is open....
  3. Formulas

    in Windows 10 Network and Sharing
    Formulas: is there a way to use LOOKUP or any other formula to add values from a large number of different sheets in the same file? https://answers.microsoft.com/en-us/windows/forum/all/formulas/764e8940-6ae1-4aed-a8d0-dc28d60c4372
  4. Search in Outlook puts your results on top

    in Windows 10 News
    Search in Outlook puts your results on top: Today, we’re delighted to share updates in Outlook that bring your search results to the top of your app experience, add top results and relevant suggestions to the Search box as well as new ways to find what you need when you search in Outlook on the go. We recognize that...
  5. Assure use pin instead of passwords on cell phone

    in Windows 10 Software and Apps
    Assure use pin instead of passwords on cell phone: I just got a message to download an ASSURE app for phone so I can use a pin instead of remembering all password. I already did this to my desktop computer, MSN is my provider & home page, BUT how do I enter a pin on the phone, so I do not have to remember passwords? my...
  6. Protect only formulas from delete/backspace allow edit in cells

    in Windows 10 Software and Apps
    Protect only formulas from delete/backspace allow edit in cells: This seems to be a mystery online how to protect a cell (Calculations only) on a protected sheet with a formula included from being deleted when someone hits Delete or Backspace in the cell without deleting the formula as well. Is there a way to protect only the...
  7. 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...
  8. 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
  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