HI friend
Please i need a help with a formula i Use a LOOKUP Column N to Look up for Percentage
Now i Need In Column P a Formula with IF
IF N is Greater Than or Equal to 70% answer should Full and IF its less Than or Equal to 69% answer should be Half
Appreciate a help out
Please i need a help with a formula i Use a LOOKUP Column N to Look up for Percentage
Now i Need In Column P a Formula with IF
IF N is Greater Than or Equal to 70% answer should Full and IF its less Than or Equal to 69% answer should be Half
Appreciate a help out
| ILSP Offshore Vessel Tracking Time Spent-2022.xlsx | |||||
|---|---|---|---|---|---|
| N | O | P | |||
| 3126 | 100% | Prd-Island | |||
| 3127 | 100% | Prd-Island | |||
| 3128 | 60% | Rigs&Barges | |||
| 3129 | 10% | Rigs&Barges | |||
| 3130 | 15% | Rigs&Barges | |||
ILSP_Offshore_Vessel_Tracking | |||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| N3126:N3130 | N3126 | =LOOKUP(2,1/($C$12:$C$600000=L3126)/($E$12:$E$600000=M3126),($F$12:$F$600000)) |
| O3126:O3130 | O3126 | =IFERROR(VLOOKUP(M3126,Location,2,0),"") |
