| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
IF Function
I need get results in a new cell if 2 criterias from different cella are met.
i.e If A1= 1 or 2 or 3 and B1=1 then C1="Comp" but if B1=0 then C1="Non-Comp" Thanks for your help -- Benny |
|
#2
|
|||
|
|||
|
Benny
One way. In C1: =IF(B1=0,"Non-Comp",IF(AND(B1=1,OR(A1={1,2,3})),"Comp","Not defined")) -- Best Regards Leo Heuser Followup to newsgroup only please. "Benny" skrev i en meddelelse ... I need get results in a new cell if 2 criterias from different cella are met. i.e If A1= 1 or 2 or 3 and B1=1 then C1="Comp" but if B1=0 then C1="Non-Comp" Thanks for your help -- Benny |
|
#3
|
|||
|
|||
|
Thanks, Leo.
"Leo Heuser" wrote: Benny One way. In C1: =IF(B1=0,"Non-Comp",IF(AND(B1=1,OR(A1={1,2,3})),"Comp","Not defined")) -- Best Regards Leo Heuser Followup to newsgroup only please. "Benny" skrev i en meddelelse ... I need get results in a new cell if 2 criterias from different cella are met. i.e If A1= 1 or 2 or 3 and B1=1 then C1="Comp" but if B1=0 then C1="Non-Comp" Thanks for your help -- Benny |
|
#4
|
|||
|
|||
|
You're welcome, Benny.
"Benny" skrev i en meddelelse ... Thanks, Leo. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Hybrid Mode
