+ Reply to Thread
Results 1 to 6 of 6

Help with formula to pull a number from a cell on one to another and changing it

  1. #1
    Registered User
    Join Date
    11-06-2017
    Location
    Sandy Hook, KY
    MS-Off Ver
    2010
    Posts
    9

    Help with formula to pull a number from a cell on one to another and changing it

    I have two tables on one worksheet. I need to pull a number from one table (C3) and place it in another table cell (J3) and change that number to 16. Any suggestions? Thanks in advance.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,451

    Re: Help with formula to pull a number from a cell on one to another and changing it

    Hi Lagina,

    Wow!! If you're going to change the number to 16 in the end, why does it matter what number you pull from the table in the first place? We'd need to see a sample of what you are trying to do to understand this question and give a possible answer.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    11-06-2017
    Location
    Sandy Hook, KY
    MS-Off Ver
    2010
    Posts
    9

    Re: Help with formula to pull a number from a cell on one to another and changing it

    I guess it doesn't really matter what number is in the original cell as long as it is above 0 then I need it to show 16 in the other cell.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2507 Build 16.0.19029.20136) 64-bit
    Posts
    31,550

    Re: Help with formula to pull a number from a cell on one to another and changing it

    in J3 of Sheet2

    =IF(Sheet1!C3>0,16,0)

  5. #5
    Registered User
    Join Date
    11-06-2017
    Location
    Sandy Hook, KY
    MS-Off Ver
    2010
    Posts
    9

    Re: Help with formula to pull a number from a cell on one to another and changing it

    Thanks! Works perfectly

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2507 Build 16.0.19029.20136) 64-bit
    Posts
    31,550

    Re: Help with formula to pull a number from a cell on one to another and changing it

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

+ 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. drag formula to new cell keeping cell but changing worksheet number
    By TREBOR74 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-26-2017, 11:10 PM
  2. Formula for Changing Cell Number If Other Cell is Different
    By co453629 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2015, 07:34 AM
  3. formula cell column and row number changing when populating thenext cell row
    By PROENGINEER in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2014, 03:43 PM
  4. Changing cell number with in formula with another cell
    By nappy1001 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-07-2013, 04:37 AM
  5. Replies: 6
    Last Post: 09-12-2012, 05:16 PM
  6. Replies: 5
    Last Post: 06-20-2012, 08:39 AM
  7. changing a cell to number format using a formula
    By pmetzak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2008, 02:56 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