tvsramesha
New Member
- Joined
- Aug 12, 2016
- Messages
- 13
Hi -
I've been trying for a simple formula =IF(OR(H4>9.01),”1Point”,IF(OR(H4>3,H4<6),"2Point",IF(OR(H4>6.01,H4<9),"3Point")))
to check if values of a cell >3<6 name it as 2point, if values >6<9 name it as 3point, and if values>9 name it 1point, need suggestions to correct it
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I've been trying for a simple formula =IF(OR(H4>9.01),”1Point”,IF(OR(H4>3,H4<6),"2Point",IF(OR(H4>6.01,H4<9),"3Point")))
to check if values of a cell >3<6 name it as 2point, if values >6<9 name it as 3point, and if values>9 name it 1point, need suggestions to correct it
SHADE-PASS | Error categorization | |
Automode | ||
Sensor-12Sensor-19 | ||
Sensor-10Sensor-18 | 5.51 | 2Point |
Sensor-18Sensor-29 | 11.42 | #NAME? |
Sensor-05Sensor-05 | 11.42 | #NAME? |
Sensor-16 | 9.06 | #NAME? |
Sensor-15 | 21.26 | #NAME? |
Sensor-20Sensor-13 | 25.98 | #NAME? |
Sensor-20 | 15.35 | #NAME? |
Sensor-19 | 7.09 | 2Point |
Sensor-29 | 17.72 | #NAME? |
Sensor-15Sensor-23 | 60.24 | #NAME? |
Sensor-06 | 61.02 | #NAME? |
Sensor-06 | 25.98 | #NAME? |
Sensor-22 | 21.26 | #NAME? |
Sensor-03 | 30.31 | #NAME? |
Sensor-25 | 32.68 | #NAME? |
Sensor-23 | 19.69 | #NAME? |
Sensor-06 | 30.71 | #NAME? |
Sensor-07 | 40.55 | #NAME? |
Sensor-23 | 22.05 | #NAME? |
Sensor-05 | 11.81 | #NAME? |
Sensor-05 | 13.78 | #NAME? |
Sensor-0æ | 14.57 | #NAME? |
Sensor-18 | 16.54 | #NAME? |
Sensor-29 | 62.20 | #NAME? |
Sensor-14Sensor-16 | 64.57 | #NAME? |
Sensor-21 | 53.15 | #NAME? |
Sensor-04 | 83.07 | #NAME? |
Sensor-28 | 96.85 | #NAME? |
Sensor-03 | 85.83 | #NAME? |
Sensor-29 | 47.64 | #NAME? |
Sensor-01Sensor-29 | 50.00 | #NAME? |
Sensor-06Sensor-06 | 91.34 | #NAME? |
Sensor-20Sensor-23 | 95.67 | #NAME? |
<colgroup><col><col><col></colgroup><tbody>
</tbody>