Excel 2016 (Windows) 64 bit | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Full | 10 | IF(A1="Full",10) | ||
2 | Half | 5 | IF(A1="Half",5) | ||
3 | Zero | 0 | IF(A1="Zero",0) | ||
4 | N/A | IF(A1="N/A","") | |||
5 | |||||
6 | Text | Result | |||
7 | Full | 10 | |||
8 | Half | 5 | |||
9 | Zero | 0 | |||
10 | N/A | ||||
Hoja1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =VLOOKUP($A1,$A$7:$B$10,2,0) | |
B2 | =VLOOKUP($A2,$A$7:$B$10,2,0) | |
B3 | =VLOOKUP($A3,$A$7:$B$10,2,0) | |
B4 | =VLOOKUP($A4,$A$7:$B$10,2,0) | |
B10 | ="" |
-A-- B- -C-
1 Full 10 75%
2 Half 5
3 N/A