Home |
Search |
Today's Posts |
#1
|
|||
|
|||
forumal does not work
Dear
A table as below. Column 1 BOX 1 Column 2 1-4 15 5-9 16 10 or above 17 BOX 2 Colurm 3 Column 4 1-2 10 3-4 12 5-7 14 8 or above 16 Box 1 = =VLOOKUP(IF(E85<=4.99,"1-4",IF(E85=5,IF(E85=10,"10 or above","5-9"))),$C$99:$D$101,2,0) Box 2 = VLOOKUP(IF(E85<=2.99,"1-2",IF(E85=3,IF(E85=5, "5-7",IF(E85=8,"8 or above","3-4")))),$C$104:$D$107,2,0) * I am not show all data with security isseus. Thanks 111.COM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
My links no longer work . . . | Excel Discussion (Misc queries) | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
Service work order | Charts and Charting in Excel | |||
How do I ensure dates inputted are during the work week? | Excel Worksheet Functions |