Hello there.
I have basic knowledge of Excel and some of the formulars, and now I need some help with the following.
I want a function/formular to calculate the highest or lowest possible value of a sum in column A, based on a given number that must be split into 1-5 cells in column D (That given number = sum of the 1-5 cells). Each number in these cells are connected to a separate sheet, that generates the value in column A (main sheet).
For example (see attached document), if I choose the number 100, I want the sheet to calculate the highest or lowest possible value of the sum of cell A3:A7, by optimizing all values in D3:D7 with all real numbers (up to 2 max decimal places) from 0 to 100 (the given number). All those numbers in B3:B7 will then generate the lowest or highest value by distributing my given number in the 5 cells in column D.
All help is appreciated, thanks.
//
Rune H.
Bookmarks