I need help with a formula. I need values for cells A1 and B1 that equals
the sum of cells C1:Z1. A1 cannot exceed the total of 10 and B1 equals the
rest of the total sum of C1:Z1.

Example: If the sum of C1:Z1 = 100, How do I get A1 = 10 and B1=90
automatically? Please help.