Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
First off, I know I am a complete idiot at using Excel. That being said,
here is what I want to do. I have been working on a dice-based roleplaying game for over four years and I just revamped the entire system of how things work for creating new characters. What I want to do is help speed up the process of creating a new character by having excel do most of the work. Here is what I do right now: I have excel randbetween the minimum and maximum values for each of the ten stats and then manually type them into the appropriate places. After that I manually ad in the modifier for another part of the sheet based on class. What I want to do: I want to have a table with all the stats in them that transfers over the stats to the sheet when someone enters the race of the character and hits calculate. I want to have a table with all the modifiers (basically the formula is "=(Stamina*2)+Strength+(Modifier*(Level-1))" and the modifier is between 0 and 14.) in it that puts the modifier where it needs to go depending on the class of the character. What I think I have to do: If then statements that are 15 "if, then"s long that confuse the heck out of me (one for each possible race). Then I will need to copy and past that for each of the ten stats and adjust the row that the statement is targeting for each cell. All in all, I'm really confused. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Change Data In Pivot Table | New Users to Excel | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) |