- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 09, 2024 06:18 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 09, 2024 06:40 AM
It looks like a divide by zero situation. If so, and assuming the rest of the formula is ok, try something like
IF( COUNTA({1st}, {2nd}, {3rd}, {4th}, {5th}, {6th}, {7th}, {8th}, {9th}, {10th})=0 , 0 , VALUE(SUBSTITUTE(SUBSTITUTE({Tuition (from KCIT Tracker)}, "$", ""), ",", "")) / ({Payment Amounts} * COUNTA({1st}, {2nd}, {3rd}, {4th}, {5th}, {6th}, {7th}, {8th}, {9th}, {10th})))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 09, 2024 06:46 AM
So it looks like its working when nothing is checked, (none of the checkboxes) but then when one of the checkboxes is checked, it gives another error code 😞
