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. |
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 |