# Assistance learning IF forumula and a THEN Forumula between Multiple Sheets

1. ## 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. ## 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. ## 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.``

4. ## 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. ## 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. ## 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. ## 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,"")

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

#### 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