I am typing this function in cell BR26 -
=IF(BF26="","",IF(BF26<10,"GOOD",IF(BF2610<20,"FA IR","POOR"))). If I have
from 1 to 9 in cell BF26 it reads GOOD but anything above 10 cell BR6 reads
POOR. What is wrong with my formula?
--
Thanks, Loren

Your formula does not work but the IF function certainly does, you need to
add AND

=IF(BF26="","",IF(BF26<10,"GOOD",IF(AND(BF26=10,B 26<20),"FAIR","POOR")))

also note that I put
= 10
or else you wouldn't have included 10 at all


--


Regards,


Peo Sjoblom


"Loren" wrote in message
...
I am typing this function in cell BR26 -
=IF(BF26="","",IF(BF26<10,"GOOD",IF(BF2610<20,"FA IR","POOR"))). If I have
from 1 to 9 in cell BF26 it reads GOOD but anything above 10 cell BR6
reads
POOR. What is wrong with my formula?
--
Thanks, Loren

IF(BF2610<20,... is not valid syntax for what you presumably intend.

IF(AND(BF2610,BF26<20),... is what you are trying to say, but of course you
have omitted the case where BF26 is *equal* to 10 (so this would give POOR,
along with the cases for BF26=20). If this should be included in the
condition, as IF(AND(BF26=10,BF26<20),..., then all you need to say is
IF(BF26<20,... because you've already tested for BF26<10 so you don't go on
to the later test unless BF26=10.
--
David Biddulph

"Loren" wrote in message
...
I am typing this function in cell BR26 -
=IF(BF26="","",IF(BF26<10,"GOOD",IF(BF2610<20,"FA IR","POOR"))). If I have
from 1 to 9 in cell BF26 it reads GOOD but anything above 10 cell BR6
reads
POOR. What is wrong with my formula?
--
Thanks, Loren

Try this
=IF(BF26="","",IF(BF26<10,"GOOD",IF(BF26<20,"FAIR" ,"POOR"))).
--
Wag more, bark less


"Loren" wrote:

I am typing this function in cell BR26 -
=IF(BF26="","",IF(BF26<10,"GOOD",IF(BF2610<20,"FA IR","POOR"))). If I have
from 1 to 9 in cell BF26 it reads GOOD but anything above 10 cell BR6 reads
POOR. What is wrong with my formula?
--
Thanks, Loren

Loren --

Try

=IF(BF26="","",IF(BF26<10,"Good",IF(BF26<20,"Fair" ,"Poor")))


HTH

"Loren" wrote:

I am typing this function in cell BR26 -
=IF(BF26="","",IF(BF26<10,"GOOD",IF(BF2610<20,"FA IR","POOR"))). If I have
from 1 to 9 in cell BF26 it reads GOOD but anything above 10 cell BR6 reads
POOR. What is wrong with my formula?
--
Thanks, Loren

On Mon, 5 May 2008 09:16:02 -0700, Loren
wrote:

BF2610<20

Not sure how you derived this syntax.

If what you want is to test for the condition where BF26 is greater than 10 and
also less than 20, the proper syntax is:

AND(BF2610,BF26<20)

If you want something else, you'll need to spell it out in more detail.



--ron