| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 Different Values
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? -- Thanks, Loren |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3 Different Values
Change the IF(BF3210<20,....
to IF(AND(BF3210,BF32<20),.... Hope this helps. -- John C "Loren" wrote: 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? -- Thanks, Loren |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Linear Mode
