| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Tagging" a cell based on another
What I'm trying to do is to get a specific response word to display if a
certain criteria is or isn't met. Example: "Great Job!" to display in a cell if trigger cell is 95% or higher or "Needs Work" if trigger cell is 94% or lower. I am using Excel 2003. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Tagging" a cell based on another
Try something like this:
If the test value is in A1 B1: =LOOKUP(N(A1),{0,1,95},{"","Needs work","Great Job!"}) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Bueller, Ferris" wrote: What I'm trying to do is to get a specific response word to display if a certain criteria is or isn't met. Example: "Great Job!" to display in a cell if trigger cell is 95% or higher or "Needs Work" if trigger cell is 94% or lower. I am using Excel 2003. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Tagging" a cell based on another
=IF(G12=95%,"Great Job","More work required")
assumes your % is in G12 "Bueller, Ferris" wrote: What I'm trying to do is to get a specific response word to display if a certain criteria is or isn't met. Example: "Great Job!" to display in a cell if trigger cell is 95% or higher or "Needs Work" if trigger cell is 94% or lower. I am using Excel 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill a cell based on another cell | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
