muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
i have a problem to data lookup with 3 criteria number (positive percentage number,negative percentage number,zero number)
for easy to understand maybe like below layout table :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<tbody>
</tbody>
note :
all numbers (as criteria) are random
i hope someone would help me out..
cheers..
.sst
i have a problem to data lookup with 3 criteria number (positive percentage number,negative percentage number,zero number)
for easy to understand maybe like below layout table :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
data | criteria | preference |
---|---|---|
Grade a | positive number | excellent |
Grade a | negative number | worst |
Grade a | zero number | equal |
Grade b | positive number | good |
Grade b | negative number | bad |
Grade b | equal | equal |
lookup/as target | as data (GIVEN) | expected result |
Grade a | 10% (random & as positive) | excellent |
Grade a | 0 | ? |
Grade b | -27% | ?? |
<tbody>
</tbody>
note :
all numbers (as criteria) are random
i hope someone would help me out..
cheers..
.sst
Last edited: