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

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

This comparison is meaningless to Excel... BF3210<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.

--
Rick (MVP - Excel)


"Loren" wrote in message
...
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

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

"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

Hi,

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

"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

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

"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