Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Command
I created an advertising opportunity score sheet. When I arrive at the total
score I would like excel to display some words telling what the number means in terms of advertising opportunity Examples - If the total is any of the following the text should be displayed below the score or beside the score. ..90 - 1.0 = extraordinary opportunity ..80 - .89 = excellent opportunity ..70 - .79 = very good ..60 - .69 = good ..50 - .59 = average opportunity ..40 - .49 = poor ,30 - .39 = very poor I hope I am making sense. Thank you Derrick |
#2
|
|||
|
|||
Take a look at the VLOOKUP function.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Derrick Robinson" wrote in message news:C2ume.4604$zb.3814@trndny06... I created an advertising opportunity score sheet. When I arrive at the total score I would like excel to display some words telling what the number means in terms of advertising opportunity Examples - If the total is any of the following the text should be displayed below the score or beside the score. .90 - 1.0 = extraordinary opportunity .80 - .89 = excellent opportunity .70 - .79 = very good .60 - .69 = good .50 - .59 = average opportunity .40 - .49 = poor ,30 - .39 = very poor I hope I am making sense. Thank you Derrick |
#3
|
|||
|
|||
Hi!
Here's one way. Invert your table, get rid of the "-" and the "=" so that it looks like this: H1..........I1..........J1 0.3....... 0.39........ very poor 0.4....... 0.49........ poor 0.5....... 0.59........ average opportunity 0.6....... 0.69........ good 0.7....... 0.79........ very good 0.8....... 0.89........ excellent opportunity 0.9....... 1............. extraordinary opportunity The table is in the range H1:J7. Assume your total score is in cell A1. In B1 enter this formula: =IF(OR(A1="",A1<0.3),"",VLOOKUP(A1,H1:J7,3,1)) Note: *any* score greater than 0.9 will return extraordinary opportunity. Biff "Derrick Robinson" wrote in message news:C2ume.4604$zb.3814@trndny06... I created an advertising opportunity score sheet. When I arrive at the total score I would like excel to display some words telling what the number means in terms of advertising opportunity Examples - If the total is any of the following the text should be displayed below the score or beside the score. .90 - 1.0 = extraordinary opportunity .80 - .89 = excellent opportunity .70 - .79 = very good .60 - .69 = good .50 - .59 = average opportunity .40 - .49 = poor ,30 - .39 = very poor I hope I am making sense. Thank you Derrick |
#4
|
|||
|
|||
Thanks to Chip & Biff. Points taken
Derrick "Biff" wrote in message ... Hi! Here's one way. Invert your table, get rid of the "-" and the "=" so that it looks like this: H1..........I1..........J1 0.3....... 0.39........ very poor 0.4....... 0.49........ poor 0.5....... 0.59........ average opportunity 0.6....... 0.69........ good 0.7....... 0.79........ very good 0.8....... 0.89........ excellent opportunity 0.9....... 1............. extraordinary opportunity The table is in the range H1:J7. Assume your total score is in cell A1. In B1 enter this formula: =IF(OR(A1="",A1<0.3),"",VLOOKUP(A1,H1:J7,3,1)) Note: *any* score greater than 0.9 will return extraordinary opportunity. Biff "Derrick Robinson" wrote in message news:C2ume.4604$zb.3814@trndny06... I created an advertising opportunity score sheet. When I arrive at the total score I would like excel to display some words telling what the number means in terms of advertising opportunity Examples - If the total is any of the following the text should be displayed below the score or beside the score. .90 - 1.0 = extraordinary opportunity .80 - .89 = excellent opportunity .70 - .79 = very good .60 - .69 = good .50 - .59 = average opportunity .40 - .49 = poor ,30 - .39 = very poor I hope I am making sense. Thank you Derrick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract Command in Excel 1 | Excel Discussion (Misc queries) | |||
Why do Command Buttons get stacked after print preview? | New Users to Excel | |||
Help requested for an Excel Toolbar command | Excel Discussion (Misc queries) | |||
command button in excel will move when print. | Excel Discussion (Misc queries) | |||
canot remove command from FILE MENU | Excel Discussion (Misc queries) |