I am sure this is easy, but I cannot get my head around it this afternoon.
What I want the formula to say is:
If Q3=A, then use the text in C3. If Q3=B, then use the text in E5.
Any help would be appreciated. Thanks in advance.
I am sure this is easy, but I cannot get my head around it this afternoon.
What I want the formula to say is:
If Q3=A, then use the text in C3. If Q3=B, then use the text in E5.
Any help would be appreciated. Thanks in advance.
Last edited by kirkjharris; 12-20-2013 at 06:30 PM.
Hi kirk,
Maybe something like the below?
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
TRY
=IF ( Q3="A", C3, IF(Q3= "B", E5, "what to do if Q3 does not equal A or B" ) )
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Got it to work! Thanks for everyone's assistance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks