Using IF function with multiple percentage parameters

Question

So, I have three parameters 92%, 95% & 98% and if output remains < 92% then target "Not Achieved". >92% Trarget achieved, >95% Stretch Target Achieved, >98% Super Stretch Target Achieved.

Using If function I have tried but not getting the desired result for the two parameters.

Formula I am using

=IF(L7<91.98,"Not Achieved",IF(L7>=91.99,"Target Achieved",IF(L7<=94.99,"Target Achieved",IF(L7>=94.99,"Stretch Target",IF(L7<=97.99,"Stretch Target",IF(L7>=98,"Super Stretch Target"))))))

Any help.

Collection Achieved	Targets	Achievement
2,027,521,672.11	63.88	Not Achieved
231,284,711.66	94.98	Target Achieved
200,394,998.75	91.38	Not Achieved
337,645,915.79	101.28	Target Achieved
242,340,959.79	80.38	Not Achieved
320,413,900.00	150.46	Target Achieved
235,000,000.00	96.94	Target Achieved
240,430,679.12	96.20	Target Achieved
220,010,507.00	106.10	Target Achieved

Answer 1

Hi Abhishek,

when you are checking for smaller (<) you must start from the smallest number to the largest number.

Another suggestion for your peoblem:

=VLOOKUP(L7,{0,"Not Achieved";92,"Target Achieved";95,"Strech Target Achieved";98,"Super Streched Target Achieved"},2.1)

Claus

Answer 2

=IF(L7<92,"Not Achieved",IF(L7<95,"Target Achieved",IF(L7<98,"Stretch Target","Super Stretch Target")))

Answer 3

Thanks @Snow Lu MSFT & @Claus B.

I was going the longest route. Appreicate your replies. It's solved now.