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	1 or 0	TRUE or FALSE
2	1	TRUE			10

<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>
</tbody>

 

[Fluff]

Definitely a backwards move IMO.

 

[TAPS_MikeDion]

From the Microsoft Website:

"The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions."

I added the red. After reading that, I see that the IFS function is definitely something you have to think carefully about before using.

Thanks for the heads-up Fluff!

 

[Fluff]

Whilst that is true, it doesn't tell you that it evaluates every single part of the formula regardless, unlike the nested If functions.

For something fairly simple, such as your formula in post#8 it's not a problem, but for more complicated ones it can definitely slow things down.
So as you said

think carefully about before using.

 

[TAPS_MikeDion]

Agreed.