How to control individual functions in excel chart?

Microsoft Excel Help.. Please n Thank you?

• Hello, I've never used microsoft excel before and i am having extreme difficulty doing a question on an assignment. The assignment is to create a spreadsheet where a Player pays $4.00 to roll a die and is paid $1 x the number rolled (ex. 2=$2, 6=$6). Player rolls die 100x's. chart headings are: A- Roll# B- Result C- Cumulative result (dont know what this means) D- Cumulative avg E- Income Profit F- cumulative profit I've figued out the functions for Roll# and Result which i just randomized but i don't know how to do the other functions for the other cells. Can Somebody please Help me!??? i've been at it for 2days all ready....PLEASE?? thank you

• Answer:

  Assume A1:F1 have all the column titles you got there. A2:A102 put 1 to 101, just to make it over a 100 rolls record for the player B2:B102 put your formula to generate random number from 1-6, here's mine if you want a cross ref. =INT(RAND()*6)+1 C2 put =B2 , C3 put =B3+C2 ,then copy C3 down to C102 , that's the cumulative of points from each roll onward D2 put =C2 , D3 put =C3/A3 ,then copy D3 down to D102 , that's the cumulative average (cumulative of points/rounds) E2 put =B2*1-4 copy E2 down to E102, income for each round F2 put =E2 , F3 put =E3+F2, copy F3 down to F102, that's the cumulative profit Hope this helps.