I am trying to come up with a spreadsheet that will break a single number down into multiple cells. The results shown in the cells will have excel minimum value of zero along with the first cell having a maximum of 20, the second cell maximum of 5 and third cell with no maximum. I have come up with solutions for the first and third but not the second cell.
Solved by A. B. in 26 mins