Geek asks and answers

IF attachments in Excel 2010

How can I nest IF expressions in Excel 2010? I found my inspiration when trying to organize data from Evolus Pencil Support Tickets .

Here is my desired result: I want to nest IF statuses to choose between different levels of state such as Fixed, New, Invalid, Done, Duplicate, etc. However, I had to make some tables to achieve this, and when I tried to test it, the IF statement gives me the first choice (fixed).

Here is the formula to check if the number is 1-6 and is added to the number, and the state level:

=IF(U2="1",
CONCATENATE(VALUE(U2),$V$2,IF(U2="2",
CONCATENATE(VALUE(U2),$W$2,IF(U2="3",
CONCATENATE(VALUE(U2),$X$2,IF(U2="4",
CONCATENATE(VALUE(U2),$Y$2,IF(U2="5",
CONCATENATE(VALUE(U2),$Z$2,IF(U2="6",
CONCATENATE(VALUE(U2),$AA$2,"NO")

The result, however, in the corresponding cells: Cell - U2 1FixedFALSE Cell - U3 false

Please see the table here.

http://win7guruquestions.posterous.com/my-spreadsheet-illustrating-selection-and-if

, .

+3
1

.

=IF(U2="1",CONCATENATE(VALUE(U2),$V$2),
IF(U2="2",CONCATENATE(VALUE(U2),$W$2),
IF(U2="3",CONCATENATE(VALUE(U2),$X$2),
IF(U2="4",CONCATENATE(VALUE(U2),$Y$2),
IF(U2="5",CONCATENATE(VALUE(U2),$Z$2),
IF(U2="6",CONCATENATE(VALUE(U2),$AA$2),"NO"))))))

, U2 .

:

=IF(AND(VALUE(U2)>=1,VALUE(U2)<=6),U2&INDEX($V$2:$Z$2,1,VALUE(U2)),"NO")
+6

More articles:


All Articles