Try the below. You cannot validate like BF3210<20

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

If this post helps click Yes
---------------
Jacob Skaria


"Loren" wrote:

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(BF3210<20,"FA IR","POOR")))
What did I do wrong?
--
Thanks, Loren