Can anyone help with this:
If the sum of C1:Z1 = 100, How can I get a value for A1 that never exceeds
10 AND B1 to equal the difference of C1:Z1 and A1 (B1=90 in this example)?