I apologise if this is is the wrong area etc. I really need help on the following.
I have a spreadsheet for university in which I have two spaces to input percentages. When a percentage is put into one space the other percentage is automatically added so they add up to 100. Easy.
So I then have other data etc spread around and basically I have one box which combines data from elsewhere and BOTH percentages in relation to data in a formula to create a number. This is also not the problem.
Finally and to the point my question is: How can I create a formula or command or anything so that the spreadsheet will automatically find the two percentages which produce the highest number from my formula, also the lowest number? Currently I just input percentages but I know that it must be possible to have excel work out which two yield the highest number.
Thanks, I apologise for gramma, spelling, not being very clear and the long winded nature of the question.
Bookmarks