Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula With A Minimum Value
Funds Available £451.78
Capital % Share £1,478.30 £33.94 £19.00 £0.44 £12,356.78 £283.69 £5,782.23 £132.75 £41.87 £0.96 Total £19,678.18 £451.78 Im on Excel 2007 and have a spreadsheet where cell D5 shows funds of £451.78 that have to be split in proportion to the 5 Capital amounts in cells C8 to C12 but with a minimum amount of £1. I get the % Share by dividing the total in D5 by the Total Capital in C13 and multiplying by the Capital in C8 - $D$5/$C$13*C8 and autofilling down. Whats the formula to get a minimum of £1 in any % Share cell with the remaining Available Funds split in proportion to the remaining Capital amounts? -- TIA Tim |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula With A Minimum Value
Here is a shabby little trick:
Pre-assign each of the five one £ to start. Then distribute the remaining £446.78 to each as you have done. -- Gary''s Student - gsnu200844 "Tim" wrote: Funds Available £451.78 Capital % Share £1,478.30 £33.94 £19.00 £0.44 £12,356.78 £283.69 £5,782.23 £132.75 £41.87 £0.96 Total £19,678.18 £451.78 Im on Excel 2007 and have a spreadsheet where cell D5 shows funds of £451.78 that have to be split in proportion to the 5 Capital amounts in cells C8 to C12 but with a minimum amount of £1. I get the % Share by dividing the total in D5 by the Total Capital in C13 and multiplying by the Capital in C8 - $D$5/$C$13*C8 and autofilling down. Whats the formula to get a minimum of £1 in any % Share cell with the remaining Available Funds split in proportion to the remaining Capital amounts? -- TIA Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimum Formula | Excel Discussion (Misc queries) | |||
Minimum array formula. | Excel Worksheet Functions | |||
maximum/minimum value in formula | Excel Discussion (Misc queries) | |||
Minimum Formula | Excel Discussion (Misc queries) | |||
How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions |