Construct a table somewhere on the sheet with two columns, first one times,
second one the words.

Start the times column from 0:00 and add the other times to give a table
with the time intervals that you want and the words that you want to
display. Then enter the formula:

=VLOOKUP(C1,D1:E7,2)

with the "overall time" in C1 and the table in D1:E7

the table can of course be anywhere on the sheet and can even be hidden by
hidine the olumns and it will still work.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"TEX" wrote in message
...

Greetings,

I am new to this forum and have a question about what Excel is
capable of. I asked around with friends and co-worker only to discover
that I know more about Excel than they do. I created a sport specific
score sheet (scores based on time) in which stage times, time
penalties, etc. are summed and placed in an "overall time" cell. So
far so good (everything works as planned). Now what I wish to do is
have, not a number, but a word such as "novice" show up in a "rating"
cell if the value in the "overall time" cell falls between two time
limits and a different word such as "expert" show up in the "rating"
cell if the value in the "overall time" cell falls between another
range of times. There will be 6 ratings all together. I played with
bracket, less than, greater than, or?, etc, but nothing seems to work
and I find nothing on it in the help section that comes with the
program. I don't know if Excel is even capable of doing this, although
I suspect that it is. I could use some help. I don't expect a
detailed explanation, although that would be nice, but I am hoping for
some guidance as to exactly where I might find instructions aimed at a
seasoned novice.

Thanks - TEX


--
TEX
------------------------------------------------------------------------
TEX's Profile:
http://www.excelforum.com/member.php...o&userid=26720
View this thread: http://www.excelforum.com/showthread...hreadid=399752