Spreadsheet: 833801d1687262243-using-mod-and-if-to-find-cell-value-vs-reference-and-show-if-divisible-but-i-have-an-issue-fvf_sample-aligw
Sheet: Data Sheet

 |  | Weight Goals Breakdown |  | Teams |  |  |  |  |  |  |  |  |  | Total Players
Week Date | 2023-06-18 00:00:00 |  |  | Black | White |  |  |  | Height Conversion Calc |  |  |  |  | Black
 |  | Totals |  |  |  |  |  |  |  |  |  |  |  | White
 |  | Players [NAME]? |  |  |  |  |  |  | POTW Straw Poll Link
 |  | [NAME]?
 |  |  | Food Tracking?
 |  | 5/10/15% Milestone?
 |  | [NAME]?
 |  |  | [NAME]?
 |  |  | Borrowed Players | 0 | 0
 |  |  |  |  | Current |  |  |  | Peak | Additional Goals Entry
Name | Team | Starting Weight | Starting Height | Starting BMI | Weekly Result (+/-) | Weekly BMI | Overall (+/-) | Overall %age Lost | Peak %age Lost | Hat-Trick | EXPECTED ANSWERS | Tracked Food? | POTW | Milestone Hit? | [NAME] (1st week)? | [NAME]? | Lost Weight? | Individual Goals For/Against | 2023-05-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | POTW awarded | (enter Y if Peak passes 5/10/15% on weigh in) | Between 18.5 and 24.9 |  |  |  | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg)
[NAME] | Black | 114.2 | 170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115.7 | 116.3 | 116.3 | 116.3 | 116.3 | 117.1
[NAME] | White | 154.6 | 183 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 154.6 | 154.6 | 149.7 | 152.3 | 151.7 | 151.7
[NAME] | Black
Callum Stonehouse | White | 133.2 | 180 |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  | 134.7 | 132.8 | 132.8 | 133.4 | 133.4 | 131.8
[NAME] | Black | 92.5 | 178 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 94.2 | 94 | 94 | 94 | 94 | 90.7
[NAME] | White | 129 | 180 |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  | 130 | 130 | 130 | 129.2 | 127.9 | 127.2
[NAME] | Black | 152.4 | 195 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 154.4 | 151.8 | 151.8 | 153.8 | 152 | 152
[NAME] | White | 88.6 | 175 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99.6 | 100.6 | 100.6 | 99.9 | 99.9 | 99.8
[NAME] | White | 131.9 | 170 |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  | 129.8 | 130 | 130 | 127.5 | 124.5 | 124.7
[NAME] | Black | 111.2 | 175 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 111.2 | 111.2 | 111.2 | 109.7 | 109.7 | 109.7
[NAME] | White | 104.8 | 175 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104.8 | 105.8 | 105.3 | 105.2 | 105 | 104.5
[NAME] | Black | 95.7 | 173 |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  | 97.1 | 98.3 | 97.5 | 98.4 | 97.4 | 96.5
[NAME] | Black | 100 | 173 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 100 | 100 | 100 | 100 | 100
[NAME] | Black | 154 | 191 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 149.9 | 149.9 | 149.9 | 149.9 | 149.9 | 152.1
[NAME] | White | 152 | 195 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 153 | 153 | 153 | 150 | 151.2 | 151.2
[NAME] | White | 95.8 | 180 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95.8 | 95.8 | 95.8 | 95.8 | 97.2 | 97.7
[NAME] | Black | 95.5 | 178 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99.8 | 99.8 | 95.6 | 94.6 | 93.3 | 93.4
[NAME] | Black | 96.9 | 180 |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  | 96.1 | 98 | 98.5 | 97.9 | 97.5 | 96.8
[NAME] | Black | 95 | 178 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95 | 94.6 | 94.6 | 95.9 | 95.9 | 96.4
[NAME] | White | 147.9 | 190 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 147.4 | 147 | 147 | 147 | 150.2 | 150.2
[NAME] | Black | 92.7 | 169 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92.7 | 92.7 | 92.7 | 92.7 | 92.7 | 92.7