Spreadsheet: 772590d1647380858-calculating-with-multiple-conditions-calculate-with-complex-condition
Sheet: Sheet1

MYID | Case | Result | Hrs | Weeks | Comment |  |  |  | CaseA |  |  |  |  | [NAME]
2143440 | CaseA | 11.7575 | 646 | 32 |  |  |  |  | Hrs | Result | Comment |  |  | Hrs | Result | Comment
2145008 | [NAME] | 24.06 | 2 | 23 |  |  |  |  | >=24 to <167 | > 8 to <=10 | Borderline |  |  | >=24 to <167 | > 4 to <=6 | Borderline
2145241 | [NAME] | 57.67 | 0 | 24
2145321 | CaseA | 7.6475 | 0 | 24 |  |  |  |  | CaseA |  |  |  |  | [NAME]
2152521 | [NAME] | 6.7475 | 41 | 32 |  |  |  |  | Weeks | Hrs | Result | Comment |  | Weeks | Hrs | Result | Comment
2152521 | CaseA | 11.285 | 24 | 36 |  |  |  |  | < 34 | 0 to 335 | < 10 | Indeterminate |  | < 34 | 0 to 335 | < 6 | Indeterminate
2152540 | CaseA | 8.9825 | 1016 | 37
2152619 | [NAME] | 13.36 | 36 | 27 |  |  |  |  | CaseA |  |  |  |  | [NAME]
2153168 | CaseA | 10.1 | 24 | 39 |  |  |  |  | Hrs | Comment |  |  |  | Hrs | Comment
2153326 | [NAME] | 14.34 | 1112 | 34 |  |  |  |  | < 24 | Invalid |  |  |  | < 24 | Invalid
2161871 | CaseA | 8.5875 | 24 | 39
2167990 | [NAME] | 7.56 | 27 | 37 |  |  |  |  | CaseA |  |  |  |  | [NAME]
2168402 | CaseA | 10.4675 | 24 | 38 |  |  |  |  | Hrs | Result | Comment |  |  | Age | Result | Comment
2169979 | [NAME] | 51.42 | 24 | 39 |  |  |  |  | 168 to 335 | > 6.0 | Normal |  |  | 168 to 335 | > 3.6 | Normal
2170282 | [NAME] | 66.51 | 24 | 38 |  |  |  |  | >=336 | > 5.5 | Normal |  |  | >=336 | > 3.2 | Normal
2170348 | [NAME] | 46.28 | 24 | 37
2171186 | [NAME] | 66.01 | 26 | 38 |  |  |  |  | CaseA |  |  |  |  | [NAME]
2174722 | [NAME] | 54.61 | 24 | 39 |  |  |  |  | Hrs | Result | Comment |  |  | Hrs | Result | Comment
2174910 | [NAME] | 69.91 | 272 | 39 |  |  |  |  | 24 to 167 | < 8.0 | Risk |  |  | 24 to 167 | < 4.0 | Risk
2174962 | CaseA | 13.89 | 0 | 39 |  |  |  |  | 168 to 335 | < 6.0 | Risk |  |  | 168 to 335 | < 3.6 | Risk
2178089 | [NAME] | 52.57 | 320 | 40 |  |  |  |  | >=336 | < 5.5 | Risk |  |  | >=336 | < 3.2 | Risk
2178325 | [NAME] | 54.25 | 24 | 39
2179043 | [NAME] | 54.02 | 272 | 35
2179160 | [NAME] | 38.72 | 49 | 35
2179191 | [NAME] | 53.07 | 30 | 40
2179275 | [NAME] | 31.655 | 35 | 38
2182716 | [NAME] | 67.62 | 28 | 39
2182730 | CaseA | 27.14 | 33 | 39
2182737 | CaseA | 6.6425 | 28 | 37
2183797 | [NAME] | 7.925000000000001 | 28 | 37
2183797 | CaseA | 9.4725 | 28 | 39
2188849 | CaseA | 9.7225 | 28 | 38
2188861 | [NAME] | 74.11 | 28 | 38
2196312 | CaseA | 9.5525 | 199 | 36
2196350 | CaseA | 9.135 | 473 | 37
2196403 | [NAME] | 40.76 | 25 | 40
2196421 | CaseA | 7.2075 | 26 | 39
2196500 | [NAME] | 2.1125 | 40 | 36
2184175 | [NAME] | 53.38 | 37 | 39
2196712 | [NAME] | 3.89 | 32 | 39
2196712 | CaseA | 4.3275 | 25 | 39
2196553 | [NAME] | 23.3 | 25 | 37
2201667 | [NAME] | 22.06 | 29 | 41
2204441 | [NAME] | 26.21 | 25 | 39
2204455 | [NAME] | 30.79 | 24 | 39
2205439 | [NAME] | 2.8575 | 24 | 39
2205618 | CaseA | 10.14 | 36 | 39
2201728 | [NAME] | 18.33 | 25 | 40
2197237 | [NAME] | 43.185 | 27 | 39
2207274 | CaseA | 8.8525 | 0 | 38
2208024 | [NAME] | 58.21 | 46 | 38
2208131 | [NAME] | 67.55 | 27 | 37
2208205 | CaseA | 8.9325 | 36 | 36
2209978 | [NAME] | 2.46 | 646 | 32
2210681 | CaseA | 11.2575 | 2 | 23
2210798 | CaseA | 25.26 | 0 | 24
2210805 | [NAME] | 54.245 | 0 | 24
2210989 | CaseA | 6.773333333333333 | 41 | 32
2210666 | [NAME] | 51.0575 | 24 | 36
2213526 | CaseA | 9.325 | 1016 | 37
2213550 | [NAME] | 52.35 | 36 | 27
2213556 | [NAME] | 82.1 | 24 | 39
2213588 | [NAME] | 53.05 | 1112 | 34
2213886 | [NAME] | 70.22 | 24 | 39
2216006 | [NAME] | 57.87 | 27 | 37
2217889 | [NAME] | 3.972499999999999 | 24 | 38
2217889 | CaseA | 8.030000000000001 | 24 | 39
2210864 | CaseA | 6.9125 | 24 | 38
2218235 | CaseA | 8.4375 | 24 | 37
2218263 | [NAME] | 44.11 | 26 | 38
2219827 | CaseA | 11.3575 | 24 | 39
2220086 | CaseA | 9.727500000000001 | 272 | 39
2220254 | [NAME] | 57.73 | 0 | 39
2221709 | CaseA | 7.8 | 320 | 40
2221731 | CaseA | 6.39 | 24 | 39
2222248 | [NAME] | 5.7125 | 272 | 35
2222316 | [NAME] | 40.07 | 49 | 35
2219884 | CaseA | 10.2975 | 30 | 40
2222388 | CaseA | 7.8575 | 35 | 38
2224170 | CaseA | 10.28 | 28 | 39
2224181 | CaseA | 10.5625 | 33 | 39
2224352 | CaseA | 7.062499999999999 | 28 | 37
2225952 | CaseA | 8.64 | 28 | 37
2226178 | [NAME] | 2.735 | 28 | 39
2226178 | CaseA | 7.6 | 28 | 38
2226195 | CaseA | 8.7275 | 28 | 38
2226196 | [NAME] | 62.27 | 199 | 36
2226214 | [NAME] | 65.26 | 473 | 37
2227830 | [NAME] | 62.19 | 25 | 40
2227851 | CaseA | 9.252500000000001 | 26 | 39
2227858 | CaseA | 8.98 | 40 | 36
2227876 | CaseA | 7.725 | 37 | 39
2227969 | [NAME] | 104.14 | 32 | 39
2227985 | [NAME] | 64.26 | 25 | 39
2227102 | [NAME] | 53 | 25 | 37
2228275 | CaseA | 7.037500000000001 | 29 | 41
2228437 | [NAME] | 57.55 | 25 | 39
2228443 | [NAME] | 5.605 | 24 | 39
2228443 | CaseA | 10.2625 | 24 | 39
2228631 | [NAME] | 107.94 | 36 | 39
2228645 | CaseA | 7.112500000000001 | 25 | 40
2229597 | CaseA | 7.74 | 27 | 39
2239913 | CaseA | 9.947500000000002 | 0 | 38
2239918 | [NAME] | 5.615 | 46 | 38
2239909 | CaseA | 7.535 | 27 | 37