Still won't work
 

By: Loren In: microsoft.public.excel.misc


I have a value in Cell BF32 of 13.43 and want cell BR32 to show the following:
If BF32 = 0 then leave cell BR32 blank
If BF32 is less than 10 then BR32 should = GOOD
If BF32 is from 10 to 20 then BR32 should = FAIR
and If BF32 is greater than 20 then BR32 should = POOR
Here's what I have in cell BF32 -
=IF(BF32="","",IF(BF32<10,"GOOD",IF(BF3210<20,"FA IR","POOR"))) I can get
GOOG and POOR but not FAIR. What is wrong with my formula?

Here's what I typed in the cell now and it still won't work:

=IF(Q15="","",IF(Q15<10,"GOOD",IF(AND(Q1510,Q15<2 0,"FAIR","POOR"))))

--
Thanks, Loren

--
Thanks, Loren

Still won't work
 

something like
=IF(H220,"p",IF(H2=10,"f",IF(H20,"g","")))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Loren" wrote in message
...
By: Loren In: microsoft.public.excel.misc


I have a value in Cell BF32 of 13.43 and want cell BR32 to show the
following:
If BF32 = 0 then leave cell BR32 blank
If BF32 is less than 10 then BR32 should = GOOD
If BF32 is from 10 to 20 then BR32 should = FAIR
and If BF32 is greater than 20 then BR32 should = POOR
Here's what I have in cell BF32 -
=IF(BF32="","",IF(BF32<10,"GOOD",IF(BF3210<20,"FA IR","POOR"))) I can
get
GOOG and POOR but not FAIR. What is wrong with my formula?

Here's what I typed in the cell now and it still won't work:

=IF(Q15="","",IF(Q15<10,"GOOD",IF(AND(Q1510,Q15<2 0,"FAIR","POOR"))))

--
Thanks, Loren

--
Thanks, Loren

Still won't work
 

You AND function has been left open.

=IF(Q15="","",IF(Q15<10,"GOOD",IF(AND(Q1510,Q15<2 0),"FAIR","POOR")))

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Loren" wrote:

By: Loren In: microsoft.public.excel.misc


I have a value in Cell BF32 of 13.43 and want cell BR32 to show the following:
If BF32 = 0 then leave cell BR32 blank
If BF32 is less than 10 then BR32 should = GOOD
If BF32 is from 10 to 20 then BR32 should = FAIR
and If BF32 is greater than 20 then BR32 should = POOR
Here's what I have in cell BF32 -
=IF(BF32="","",IF(BF32<10,"GOOD",IF(BF3210<20,"FA IR","POOR"))) I can get
GOOG and POOR but not FAIR. What is wrong with my formula?

Here's what I typed in the cell now and it still won't work:

=IF(Q15="","",IF(Q15<10,"GOOD",IF(AND(Q1510,Q15<2 0,"FAIR","POOR"))))

--
Thanks, Loren

--
Thanks, Loren