IF CONDITION

[avisoft20]

Dear All,
I am working on if condition, but while putting the formula it does not show the correct result. Below is the table for example.

Sr.No	Slab-1	Slab-2	Slab-3	Marks	Result
1​	10	25	50	10.00	Slab-1
2​	5	10	15	11.00	Slab-2
3​	10	25	50	86.00	Slab-3
4​	10	20	30	5.00	No Slab

i am using this formula :
=IF(B2>=E2,"Slab-1",IF(C2>=E2,"Slab-2",IF(D2>=E2,"Slab-3"," ")))
Condition is:
1. if Marks is greater than or equal to Slab-1, the result will be Slab-1.
2. if Marks are greater than or equal to Slab-2, the result will be Slab-2.
3. if Marks is greater than or equal to Slab-3, the result will be Slab-3.
Else No Slab

Thank You
Avisoft20

 

[Fluff]

You're formula & description are at odds with each other, which is correct. Also what are your expected results from that data?

 

[etaf]

EDIT
Ignore - already asked

1. if Marks is greater than or equal to Slab-1, the result will be Slab-1.

So that would mean E2 > B2

what do you need ?
do you order by Slab3 , then check slab 2 , then slab1

as in row 3 , they are all smaller

 

[Sufiyan97]

As per the expected Results provided, I could come up with

Book3
	A	B	C	D	E	F
1	Sr.No	Slab-1	Slab-2	Slab-3	Marks	Result
2	1	10	25	50	10	Slab-1
3	2	5	10	15	11	Slab-2
4	3	10	25	50	86	Slab-3
5	4	10	20	30	5	No Slab
Sheet1

Cell Formulas
Range	Formula
F2:F5	F2	=IFERROR(INDEX($B$1:$D$1,,MATCH(E2,B2:D2,1)),"No Slab")

 

[juxwillx]

What error are you getting? The conditions look correct as far as i can see