"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.

"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.

"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.