+ Reply to Thread
Results 1 to 11 of 11

Hi! Newbie here! IF function confusion!

  1. #1
    Registered User
    Join Date
    04-17-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    36

    Question Hi! Newbie here! IF function confusion!

    Hi guys,

    Not necessarily a newbie as such, more to the in-depth side of formulas.

    Lets say I have;

    TC Gold 12 3138.75
    TC Gold 24 4686.25

    I would like to know a formula that would let me find the "12" or "24" and then add a relevant number.

    Something along the lines of, "if 12 is in A4 then add 2214", "if 24 is in A5 then add 3690".

    Hope that makes sense!

    Thanks!
    Last edited by adamj1910; 04-17-2012 at 05:19 AM.

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Hi! Newbie here! IF function confusion!

    Are the values you've listed all in one column, or do they represent 2 (or more) columns?

  3. #3
    Registered User
    Join Date
    04-17-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Hi! Newbie here! IF function confusion!

    TC Gold 12 (and so on) are in A4 and down and, "3138.75" (and so on) are in D4 and down

    Thanks

  4. #4
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Hi! Newbie here! IF function confusion!

    And is it just "12" or "24" you're looking for, or do you have a list of values?

  5. #5
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Hi! Newbie here! IF function confusion!

    Welcome to the forum

    Can you attach an example spreadsheet?




    If I was able to help – PLEASE DO NOT FORGET to Click the small star icon at the bottom left of my post.

  6. #6
    Registered User
    Join Date
    04-17-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Hi! Newbie here! IF function confusion!

    test.xls ****EDIT*****

    hope this makes sense, (I transferred section to new workbook) A1 (contains 12, 24, 36, 48, 60)

    IF 12 + 2214
    IF 24 + 3690
    IF 36 + 5904
    IF 48 + 7380
    IF 60 + 9594

    I need the resulting values in D1 (or any empty cell in line with corresponding cell)

    Thanks!!
    Last edited by adamj1910; 04-17-2012 at 04:48 AM.

  7. #7
    Registered User
    Join Date
    04-17-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Hi! Newbie here! IF function confusion!

    i just attached a test of the spread, there are more values, 12, 24, 36, 48, 60

  8. #8
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Hi! Newbie here! IF function confusion!

    If Column A has 12 - then add 2214 to which column figure? Column B or COlumn C??



    If I was able to help – PLEASE DO NOT FORGET to Click the small star icon at the bottom left of my post.

  9. #9
    Registered User
    Join Date
    04-17-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Hi! Newbie here! IF function confusion!

    If Column A has 12 then add 2214 to Column C (Column B isn't entirely necessary to be honest).

    Sorry for the loss of information lol.

  10. #10
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Hi! Newbie here! IF function confusion!

    This is easiest done with a look-up table.

    I've added one in sheet 2 of your example book, and put the formula to use it in D1.

    Is this what you were looking for?

    PS. My solution uses the IFERROR function, which wasn't available prior to Excel 2007 (which your profile says you have). If the file needs to be in Excel 2003 format then please let me know.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    04-17-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Hi! Newbie here! IF function confusion!

    Hi Andrew!

    Works perfectly thanks ever so much!

    Repped!

    Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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