+ Reply to Thread
Results 1 to 8 of 8

Insert Formula into Cell

  1. #1
    Registered User
    Join Date
    02-17-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    3

    Insert Formula into Cell

    I am trying to input a formula into a cell and it does not work. I have entered same formula in other cells and no problem.

    Thanks for looking
    Lenny C

    Sorry as I did not give enough info first post. Hopefully this one better. I am attaching the spreadsheet. In cell D8 is the error I am getting. Same formula entered in K21 works good. Formula trying to enter in D8 is =sum(30*(P3*5)
    Attached Files Attached Files
    Last edited by Carvertat; 02-17-2020 at 03:08 PM. Reason: Add file

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Insert Formula into Cell

    Welcome to the forum.

    Attach the workbook, not an image of it.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Insert Formula into Cell

    What's the formula you are trying to enter?
    WHat does 'does not work' mean?
    You get an answer but not the one you expect, you get an error result, you are prevented from entering the formula....which one?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    02-17-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    3

    Re: Insert Formula into Cell

    I attached excel file in my original post.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Insert Formula into Cell

    Column D is text, change it to General & then insert your formula

  6. #6
    Registered User
    Join Date
    02-17-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    3

    Re: Insert Formula into Cell

    Fluff13, thank you as this was driving me crazy !! Changing the cell from text to general fixed the problem.

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Insert Formula into Cell

    You're welcome & thanks for the feedback

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Insert Formula into Cell

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find non blank cell in a column (range Specified) and insert formula to other cell in same
    By jpbisani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2018, 06:11 AM
  2. [SOLVED] Formula to insert future date in cell, if specific information placed in other cell
    By JeninQC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2018, 11:06 AM
  3. Insert copied cell which having formula and merged cell by using command button
    By eltigre in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2017, 12:50 AM
  4. Formula to insert text in a cell based on the date range of another cell
    By MTC2016 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2016, 09:36 AM
  5. lock and insert formula in a cell based on selection of text in another cell
    By alirazafazal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2014, 06:08 AM
  6. Replies: 5
    Last Post: 05-07-2013, 08:34 AM
  7. Auto-Insert Adjacent Cell Contents to Cell Chosen by LARGE Formula
    By Aravisea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2009, 02:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1