DragonJad
New Member
- Joined
- Apr 28, 2010
- Messages
- 37
- Office Version
- 365
- 2019
- Platform
- Windows
Hi All,
I'm having difficulties figuring out what function to use in the OUT column (B) to calculate the following:
If the number in OUT (G) is greater than the TOTAL C then it should only show the MAX of TOTAL (C) otherwise subtract the remainder from the next instance of the colour (A)
Blue is 5 TOTAL - therefore the first instance of Blue is 3 and the next should be 2, not 3 each.
Would this be a nested IF with MOD? Any advice would be appreciated! Thank you
I'm having difficulties figuring out what function to use in the OUT column (B) to calculate the following:
If the number in OUT (G) is greater than the TOTAL C then it should only show the MAX of TOTAL (C) otherwise subtract the remainder from the next instance of the colour (A)
Blue is 5 TOTAL - therefore the first instance of Blue is 3 and the next should be 2, not 3 each.
Would this be a nested IF with MOD? Any advice would be appreciated! Thank you