Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |