![]() |
|
![]() | ||
|
Subject:
Excel Formula Question
Category: Computers > Programming Asked by: flamingodee-ga List Price: $5.00 |
Posted:
04 Jul 2006 13:41 PDT
Expires: 03 Aug 2006 13:41 PDT Question ID: 743330 |
A B C 1 1 1 A 2 1 2 B 3 2 1 D 4 2 2 C 5 1 3 A 6 1 4 A 7 1 2 ? If I plug a value in A7 (say 1) and B7 (say 2) then I should get the letter in C7 based on the table - can you do it with an If Then Statement and possibly another way as well? I did figure out a Vlookup already. |
![]() | ||
|
There is no answer at this time. |
![]() | ||
|
Subject:
Re: Excel Formula Question
From: jack_of_few_trades-ga on 05 Jul 2006 04:57 PDT |
Are the numbers representative of code? I'm a bit confused as to how the letter is determined. |
Subject:
Re: Excel Formula Question
From: respree-ga on 05 Jul 2006 18:09 PDT |
What is the relationship between columns A, B & C? I don't see any connection (with any basic operators : +,-,x,/). |
Subject:
Re: Excel Formula Question
From: slipperycat-ga on 02 Aug 2006 16:38 PDT |
You can use the IF and AND in combination to get the result you want. IF can be strung together 7 times. IF takes 3 parameters the first is the logical test in this case well use AND. The second parameter is the result IF the logical test is true and the third parameter is the result if the logical test is false. By using an IF as the third parameter I'm able to do the test you're looking for. =IF(AND(A1=A7,B1=B7),C1,IF(AND(A2=A7,B2=B7),C2,IF(AND(A3=A7,B3=B7),C3,IF(AND(A4=A7,B4=B7),C4,IF(AND(A5=A7,B5=B7),C5,IF(AND(A6=A7,B6=B7),C6,0)))))) |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |