speedpro_bri
New Member
- Joined
- Jan 22, 2019
- Messages
- 1
I have someone that doesn't need to make a payment until after they reach $15,000 year to date. However, if they reach it within a month, I need to only charge them the difference, and then every month after needs to be what they actually owe.
I am trying to figure out the formula where these criteria are met
1. If royalties from total tab in january are less than 15000, return 0 (ok, no problem, I can do that formula)
2. If the sum of jan & feb royalties are less than 15000, return 0 (I can do that formula)
3. BUT if the sum of jan & february royalties are greater than 15000, then subtract the total of both months from 15000 and only give the difference in the february tab.
4. BUT also if the 15000 was met in jan, give only the difference from 15000 in january and then for february, give the correct $ from the total tab.
I am trying to figure out the formula where these criteria are met
1. If royalties from total tab in january are less than 15000, return 0 (ok, no problem, I can do that formula)
2. If the sum of jan & feb royalties are less than 15000, return 0 (I can do that formula)
3. BUT if the sum of jan & february royalties are greater than 15000, then subtract the total of both months from 15000 and only give the difference in the february tab.
4. BUT also if the 15000 was met in jan, give only the difference from 15000 in january and then for february, give the correct $ from the total tab.
