+ Reply to Thread
Results 1 to 7 of 7

Assistance learning IF forumula and a THEN Forumula between Multiple Sheets

  1. #1
    Registered User
    Join Date
    10-22-2013
    Location
    Iowa
    MS-Off Ver
    Excel 2010
    Posts
    36

    Assistance learning IF forumula and a THEN Forumula between Multiple Sheets

    Would be appreciated if some could show me an example of an IF formula. IF x in cell A6 on Sheet 2, then copy B6 sheet 2, to A5 sheet 1, THEN copy D6 sheet 2, to C5 sheet 1.

    An example of the above would be enough that I can pick it apart for my little personal project I'm working on. Thank you for your time!

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Assistance learning IF forumula and a THEN Forumula between Multiple Sheets

    Put:
    =IF(Sheet2!A6="x",Sheet2!B6,"")
    in Sheet1 A5
    and
    =IF(Sheets2!A6="x",Sheet2!D6,"")
    in Sheet1C5

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Assistance learning IF forumula and a THEN Forumula between Multiple Sheets

    Try this......

    Please Login or Register  to view this content.
    And

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Registered User
    Join Date
    10-22-2013
    Location
    Iowa
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Assistance learning IF forumula and a THEN Forumula between Multiple Sheets

    Could I put both of those IF statements in the same cell?

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Assistance learning IF forumula and a THEN Forumula between Multiple Sheets

    Cells A5 and C5 on sheet1 will have different formulas as I replied above.

  6. #6
    Registered User
    Join Date
    10-22-2013
    Location
    Iowa
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Assistance learning IF forumula and a THEN Forumula between Multiple Sheets

    yeah I udnerstand that, just wondering if it's possible to combine them so they take up less cells, I have a pet project that has taken up 100 sheets so far, so trying to cut down on space that is used up, trying to keep formulas neat and tidy pretty much.

  7. #7
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Assistance learning IF forumula and a THEN Forumula between Multiple Sheets

    But you wanted the result to be put in A5 and C5, so combining the formulas would take up the same amount of cells as you would still have two results in those cells.

    If you want to put both results in the same cell you could do:

    =IF(Sheet2!A6="x",Sheet2!B6 & " " & Sheet2!D6,"")

+ 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. Forumula to return multiple values
    By sathishkm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-25-2014, 04:35 PM
  2. Replies: 3
    Last Post: 11-05-2012, 07:58 PM
  3. assistance using text and forumula
    By twiggywales in forum Excel General
    Replies: 5
    Last Post: 02-09-2012, 07:47 AM
  4. 2 sheets forumula
    By jagguy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2007, 07:02 AM
  5. [SOLVED] How do I sum multiple cells inside a forumula?
    By SupportX in forum Excel General
    Replies: 2
    Last Post: 07-27-2005, 07:06 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