Multiple IF

[hsandeep]

I want to get 10, 20, 30 or 40 in F2 as:

F2=10 IF B2=0 AND C2=TRUE
F2=20 IF B2=0 AND C2=FALSE
F2=10 IF B2=1 AND C2=TRUE
F2=10 IF B2=1 AND C2= FALSE

ELSE
F2=0

How to accomplish.
Thanks in advance.
I am using Excel 2007
Sheet1

	B	C	D	E	F
1 or 0	TRUE or FALSE

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 94px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]TRUE[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]10[/TD]

</tbody>

 

[mikerickson]

Try

=IF(OR(B2,C2),10,20)

 

[hsandeep]

Try

=IF(OR(B2,C2),10,20)

How will I get 30 or 40?

 

[mikerickson]

The OP list of conditions doesn't mention 30 or 40

 

[hsandeep]

The OP list of conditions doesn't mention 30 or 40

Sor.y

F2=10 IF B2=0 AND C2=TRUE
F2=20 IF B2=0 AND C2=FALSE
F2=30 IF B2=1 AND C2=TRUE
F2=40 IF B2=1 AND C2= FALSE

 

[mikerickson]

Perhaps something like =CHOOSE(B2+2*C2+1, 20, 10, 40, 30)

You can adjust the return values to suit, if I got something wrong way 'round.

 

[hsandeep]

Perhaps something like =CHOOSE(B2+2*C2+1, 20, 10, 40, 30)

You can adjust the return values to suit, if I got something wrong way 'round.

Thanks mikerickson. IT WORKS

 

[TAPS_MikeDion]

Just saw you had a response from Mike.

I was going to say try something like this:

=IFS(AND(B2<>0,B2<>1),0,AND(B2=0,C2),10,AND(B2=0,C2=FALSE),20,AND(B2,C2),30,AND(B2,C2=FALSE),40)

 

[Fluff]

I would recommend keeping away from the new IFS function.
Have a look here to see why. http://excelmatters.com/2019/03/19/ifs-is-not-the-same-as-nested-if-functions/

 

[TAPS_MikeDion]

Interesting.