Joined: 18 May 2012
|Posted: Fri May 18, 2012 3:15 am Post subject: Generate value based on various inputs
I want to create a spreadsheet for a football game based on teamtalks. Below is a typical example output of what needs to happen:
Overall Teamtalk Squad Mood Match Odds Squad Morale Give talk
Pre-Match Complacent Favorite Good I expect a win
In the first two cells of the second row are values that are selected from a drop down list by the user. So when the user selects pre-match then complacent, then favorite, then good.....the value in the give talk cell should automatically produce I expect a win.
Basically I just want a template formula so that I can return a value based on a number of conditions selectable by the user through list box values. I've worked out how to create list boxes but have no clue about what formula to use.
Below is more detailed set of conditions with the give talk cell being generated by using the various values/strings combinations in the columns. In essence I'm guessing some sort of array needs to be set up so that when a certain combination
of options are selected, a specific string is produced for give talk based purely on what the user has selected for each list box:
Individual Teamtalk Score Half-time overall talk Morale Mood Player Rating Substitute? Squad Status Give talk
Half-Time Drawing Disappointing Good Normal 7.0-7.4 No Senior None
Any ideas peeps?