Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |