# Having trouble figuring out an IF statement/formula

1. ## Having trouble figuring out an IF statement/formula

I am trying to create an IF formula for, Example: "IF I enter an X in D2 then D1 should show up on another sheet in the desired location" I am new to Excel but I understand most of the basics. I have tried things like =IF(D2="X", D1=sheet2!C4) I know that this is not correct but I have managed to try different versions of this and started to get somewhere. I appreciate anyone's advise.

2. ## Re: Having trouble figuring out an IF statement/formula

You are in the right direction

=IF(D2="X",sheet2!C4,0) where this formula is entered in cell D1

=IF(RESULT, TRUE, FALSE)

3. ## Re: Having trouble figuring out an IF statement/formula

Thank you! I will try this now!

4. ## Re: Having trouble figuring out an IF statement/formula

Thank you! I will try this now!

5. ## Re: Having trouble figuring out an IF statement/formula

Thank you WinteE, I am still struggling with where this formula goes? If D14 has an X entered into it, then it would tell C14 which includes text already, to show up in a different cell on a different sheet. So I am confused as to where the formula is entered.

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