ExcelBanter - IF Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Function (https://www.excelbanter.com/excel-worksheet-functions/18000-if-function.html)

Benny

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

Leo Heuser

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

Benny

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

Leo Heuser

You're welcome, Benny.

"Benny" skrev i en meddelelse
...
Thanks, Leo.

All times are GMT +1. The time now is 10:37 PM.