Function not working

  • Thread starter Thread starter Loren
  • Start date Start date
L

Loren

I'm trying to get a cell to work 3 different functions depending on it's value.
#1 If cell value is less than 10 the cell displays "GOOD"
#2 If cell value is more than 10 but less than 20 cell displays "FAIR"
#3 If cell value is more than 20 cell displays "POOR"
This is the function I have typed in now:
=IF(BF32="","",IF(BF32<10,"GOOD",IF(BF32>10<20,"FAIR","POOR")))
What did I do wrong?
 
Try the below. You cannot validate like BF32>10<20

=IF(BF32="","",IF(BF32<10,"GOOD",IF(BF32<20,"FAIR","POOR")))

If this post helps click Yes
 
This comparison is meaningless to Excel... BF32>10<20. Try it this way...

=IF(BF32="","",IF(BF32<10,"GOOD",IF(BF32<20,"FAIR","POOR")))

Note... this works because if BF32 is less than 10, the first IF handles it,
so you don't need to test to make sure BF32 is greater than or equal to
10... it has to be if it made it past the first IF statement, so all you
need to test in the second IF statement is that BF32 is less than 20.
 
Hi,

An alternative to IF

=LOOKUP(BF32,{1,10,20},{"Good","Fair","Poor"})

A may have the thresholds wrong because your question is unclear as to which
category 10 falls into

Mike
 
Back
Top