formula help

[Guest]

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.

 

[David Biddulph]

Well, you haven't fully specified how you want to calculate the value for
A1, but one option that satisfies your incomplete spec is:
For A1, use =MIN(10,SUM(C1:Z1))
For B1, use =SUM(C1:Z1)-A1

 

[Guest]

in A1
=MIN(10,SUM(C1:Z1))
in B1
=SUM(C1:Z1)-A1