Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then statement
I have a spreadsheet that i need to do an if then statement for that I can't
figurar out. This is what I need done: Any number that equals the same as the key row needs to be displayed in the results row. See below Key B C D E F G Results 1 1 2 3 4 5 6 1 2 2 3 4 5 1 5 2 3 3 4 5 1 2 7 2 So in the results column i need to put the if then statement = If column B:F=A1 or " " then = I hope someone can understand this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then statement
=IF(ISNA(MATCH(A6,B6:F6,0)),"",A6)
-- Don Guillett Microsoft MVP Excel SalesAid Software "Kat" wrote in message ... I have a spreadsheet that i need to do an if then statement for that I can't figurar out. This is what I need done: Any number that equals the same as the key row needs to be displayed in the results row. See below Key B C D E F G Results 1 1 2 3 4 5 6 1 2 2 3 4 5 1 5 2 3 3 4 5 1 2 7 2 So in the results column i need to put the if then statement = If column B:F=A1 or " " then = I hope someone can understand this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then statement
I assume your final 2 in the example is a typo and should be 3 (so I
understand your problem), and if so you can try this in H1: =IF(COUNTIF(B1:G1,A1)0,A1,"") and copy down as required. Hope this helps. Pete On Oct 5, 2:35 pm, Kat wrote: I have a spreadsheet that i need to do an if then statement for that I can't figurar out. This is what I need done: Any number that equals the same as the key row needs to be displayed in the results row. See below Key B C D E F G Results 1 1 2 3 4 5 6 1 2 2 3 4 5 1 5 2 3 3 4 5 1 2 7 2 So in the results column i need to put the if then statement = If column B:F=A1 or " " then = I hope someone can understand this. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then statement
I don't entirely understand what you're asking for.
Are you saying that if the value in A1 is found anywhere in the range B1:F1 you want that A1 value writing into the results column in row 1, but otherwise you want " " (or perhaps you want ""?)? If so, there are a couple of things I don't understand about your examples: Where (if at all) does column G come into the calculation? Why in the third row of examples do you have a 2 in the results column, when you had a 3 in columns A and B? -- David Biddulph "Kat" wrote in message ... I have a spreadsheet that i need to do an if then statement for that I can't figurar out. This is what I need done: Any number that equals the same as the key row needs to be displayed in the results row. See below Key B C D E F G Results 1 1 2 3 4 5 6 1 2 2 3 4 5 1 5 2 3 3 4 5 1 2 7 2 So in the results column i need to put the if then statement = If column B:F=A1 or " " then = I hope someone can understand this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
IF, THEN statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |