Logical Function

**L1r** · 04-08-2009, 03:02 PM

I am trying to create a logical test with three possible results:

h2 <10.2 "needs improvement"
(if false) h2=10.2 "meets standard"
if false h2>10.2 "exceeds standard"

Basically, I am referring to a cell to determine if it meets, exceeds or does not meed a specific standard. In this case 10.2

I thought I knew excel, never learned custom functions... Any help???

**Domenic** · 04-08-2009, 03:10 PM

Try...

=IF(H2<>"",IF(H2<10.2,"Needs Improvement",IF(H2=10.2,"Meets Standard","Exceeds Standard")),"")

**L1r** · 04-08-2009, 03:19 PM

Thanls Domenic, you rock

**Domenic** · 04-08-2009, 03:24 PM

You're very welcome!

**NBVC** · 04-08-2009, 03:26 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**varme** · 10-08-2010, 11:14 AM

Great answer..But, I would like to modify second statement by using a range of data..

if a2<=85 "run",
if else 85<a2<95 "need improvement",
if else a2=>95 "stop".

Please help..Thanks..

**NBVC** · 10-08-2010, 11:15 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.