Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Nested IF/And Function
I am having trouble getting this to work. I can do about 2-3 of the
statements but stringing them all together is proving difficult. Values C3 Compared to E3. First Condition If C3=E3 return value of 1 Second Condition If C3=600 Return value of 3 Third Condition If C3E3 AND C3399 return value of 2 4th Condition If C3<400 and E3<400 return value of 1 5th Condition If C3399 and C3<E3 return value of a 1 Else return 0. That should be checked in that order. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Nested IF/And Function
That should be checked in that order.
OK...but these are duplicates: Third Condition If C3E3 AND C3399 return value of 2 4th Condition If C3E3 AND C3399 return value of 2 =IF(C3=E3,1,IF(C3=600,3,IF(AND(C3E3,C3399),2,IF( AND(C3399,C3<E3),1,0)))) -- Biff Microsoft Excel MVP "Bombay" wrote in message ... I am having trouble getting this to work. I can do about 2-3 of the statements but stringing them all together is proving difficult. Values C3 Compared to E3. First Condition If C3=E3 return value of 1 Second Condition If C3=600 Return value of 3 Third Condition If C3E3 AND C3399 return value of 2 4th Condition If C3E3 AND C3399 return value of 2 5th Condition If C3399 and C3<E3 return value of a 1 Else return 0. That should be checked in that order. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF Function | Excel Discussion (Misc queries) | |||
Nested IF Function | Excel Discussion (Misc queries) | |||
can you nested sum and round function within if function? | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |