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.
You are in the right direction
=IF(D2="X",sheet2!C4,0) where this formula is entered in cell D1
=IF(RESULT, TRUE, FALSE)
Re: Having trouble figuring out an IF statement/formula
Thank you! I will try this now!
Re: Having trouble figuring out an IF statement/formula
Thank you! I will try this now!
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks