"Tagging" a cell based on another

B

Bueller, Ferris

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

Ron Coderre

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
 
Top