Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
simultaneously work in a work book with other users | Excel Discussion (Misc queries) | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions |