Excel Formula

[clean14]

I am trying to keep track of gas money that my friend owes me for driving to and from college. I would like to create a dynamic formula that applies to all the cells in my excel spread sheet and as you enter a number into one cell that applies to the amount of miles driven it then calculates automatically how much you owe for that day. Its not necessary but it would be cool to have a cell that totals the amount in every cell as well. how can i accomplish all of this? thanks to anyone who helps.

 

[clean14]

I am trying to keep track of gas money that my friend owes me for driving to and from college. I would like to create a dynamic formula that applies to all the cells in my excel spread sheet and as you enter a number into one cell that applies to the amount of miles driven it then calculates automatically how much you owe for that day. Its not necessary but it would be cool to have a cell that totals the amount in every cell as well. how can i accomplish all of this? thanks to anyone who helps.

Bump. i would really like some help on this.

 

[hang-the-9]

http://office.microsoft.com/en-us/excel-help/CH001000513.aspx

If you can't get the answer from there, I really hope you are an english major and not about to start designing buildings or computers.