formula help
 

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.

formula help
 

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
--
David Biddulph

"rldjda" wrote in message
...
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.

formula help
 

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


"rldjda" wrote:

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.