If, Ifs and statements

[Pkocienda]

Good Afternoon,

I am looking for help in creating a formula. I have tried multiple if, ifs and statements and cannot get the desired result.

I would like the result to populate in Column G. (The result would be 1,2,3,4 or ,5)

I need help in putting this as one formula in G2. The result in G2 would be 3

If B2<C2, 1
If B2<D2, 2
IF B2<E2, 3
If B2<F2,4
If B2>=F2,5

A	B	C	D	E	F	G
Name	Rate	10th	33.33rd	66.67th	90th	Result
Getting care easily​	0.877​	0.825​	0.868​	0.900​	0.924​	​

 

[etaf]

Ifs (B2<C2, 1, B2<D2, 2, B2<E2, 3, B2<F2,4, B2>=F2,5, TRUE, 0 )

but it works left to right

 

[JamesCanale]

=IFNA(XMATCH(B21,C21:F21,1),5)

 

[etaf]

Book9
	A	B	C	D	E	F	G
1	Name	Rate	10th	33.33rd	66.67th	90th	Result
2	Getting care easily	0.877	0.825	0.868	0.900	0.924	3
Sheet1

Cell Formulas
Range	Formula
G2	G2	=IFS(B2<C2,1,B2<D2,2,B2<E2,3,B2<F2,4,B2>=F2,5,TRUE,0)

 

[Pkocienda]

Book9
	A	B	C	D	E	F	G
1	Name	Rate	10th	33.33rd	66.67th	90th	Result
2	Getting care easily	0.877	0.825	0.868	0.900	0.924	3
Sheet1

Cell Formulas
Range	Formula
G2	G2	=IFS(B2<C2,1,B2<D2,2,B2<E2,3,B2<F2,4,B2>=F2,5,TRUE,0)

Book9
	A	B	C	D	E	F	G
1	Name	Rate	10th	33.33rd	66.67th	90th	Result
2	Getting care easily	0.877	0.825	0.868	0.900	0.924	3
Sheet1

Cell Formulas
Range	Formula
G2	G2	=IFS(B2<C2,1,B2<D2,2,B2<E2,3,B2<F2,4,B2>=F2,5,TRUE,0)

Book9
	A	B	C	D	E	F	G
1	Name	Rate	10th	33.33rd	66.67th	90th	Result
2	Getting care easily	0.877	0.825	0.868	0.900	0.924	3
Sheet1

Cell Formulas
Range	Formula
G2	G2	=IFS(B2<C2,1,B2<D2,2,B2<E2,3,B2<F2,4,B2>=F2,5,TRUE,0)

Thank you for your help

 

[etaf]

you are welcome