+ Reply to Thread
Results 1 to 10 of 10

adding cells values to cells with formulas

  1. #1
    Registered User
    Join Date
    08-15-2013
    Location
    Oklahoma
    MS-Off Ver
    2007
    Posts
    3

    adding cells values to cells with formulas

    New here so hope to word my question clearly
    I used the formula =If(B4=J4,TRUE,FALSE) Answer in col. N
    I have data (numbers) in column L. If answer in N is true add number in col. L if false subtract number. I hope I gave enough information, if not pls advise. Thanks

  2. #2
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: adding cells values to cells with formulas

    Hi and welcome to the team,

    Sorry but a little more information is needed maybe even an example of what you are trying to do. You can upload a spreadsheet by clicking on the "Go Advanced" button below the post (on the right-hand side), scroll down the new page and click on "Manage Attachments", a new window opens and on the top right-hand side is a button "Add Files" (has a white-cross in a green button), browse and find your file, make sure it is in the bottom part of the window ("Attachments") then click on "Insert Inline" (bottom-right of page).

    Cheers :

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: adding cells values to cells with formulas

    Maybe something like this...

    Array entered**:

    =SUM(IF(B4:B10=J4:J10,L4:L10,-L4:L10))

    Adjust the ranges to suit.

    ** array formulas need to be entered using the key
    combination of CTRL,SHIFT,ENTER (not just ENTER).
    Hold down both the CTRL key and the SHIFT key
    then hit ENTER.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    08-15-2013
    Location
    Oklahoma
    MS-Off Ver
    2007
    Posts
    3

    Re: adding cells values to cells with formulas

    PointsWon.xlsx
    I hope this helps. Col I shows manually what my end result would look like, the numbers would change each week so would like a formulas to calculate in H col.

  5. #5
    Forum Contributor
    Join Date
    01-30-2013
    Location
    Wales
    MS-Off Ver
    Excel 2013
    Posts
    231

    Re: adding cells values to cells with formulas

    Put the formula in H4 and copy it down to the bottom of the data.

    =IF(B4=C4,+E4,-E4)

    Hope this helps

    Chris

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: adding cells values to cells with formulas

    The formula I suggested in post #3 will do what you want without having to use a separate formula for each row of data.

    If you still want a formula for each row of data then...

    Enter this formula in I4 and copy down as needed:


    =IF(B4=C4,E4,-E4)

  7. #7
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: adding cells values to cells with formulas

    Congratulations on uploading the file - well done!

    OK so first I had to change the formula in Column G to read =IF(B4=C4,"TRUE","FALSE") - looks the same but with this one we can create the next formula, which is: =IF(G4="TRUE",E4,-E4) - see the formulas in the blue colored cells.

    PointsWon 01.xlsx

    Cheers,

  8. #8
    Registered User
    Join Date
    08-15-2013
    Location
    Oklahoma
    MS-Off Ver
    2007
    Posts
    3

    Re: adding cells values to cells with formulas

    Thank you , don't know why I was making this so hard. I have senior moments from time to time.

  9. #9
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: adding cells values to cells with formulas

    You're welcome. We appreciate the feedback!

  10. #10
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: adding cells values to cells with formulas

    You're welcome crohling,

    Appreciate your feedback and I understand senior moments all too well! LOL

    Take care,

+ 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. Adding formulas to cells with data already in them...
    By Kaleidoscope in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-17-2013, 07:14 PM
  2. Adding cells with values but if cells do not have values then return blank
    By jonnykhan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-13-2012, 12:07 PM
  3. Adding additional cells to cells with formulas.
    By pjfoster in forum Excel General
    Replies: 1
    Last Post: 02-21-2012, 07:29 PM
  4. [SOLVED] Adding formulas to cells
    By Jordan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-16-2006, 11:30 PM
  5. [SOLVED] Adding cells that already have formulas
    By critter in forum Excel General
    Replies: 2
    Last Post: 09-28-2005, 02:05 AM

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