Spreadsheet help

[RadioGaGa 162]

So...I'm working on a spreadsheet and I want to Divide the number in B4 by the number in C4.

I tried =QUOTIENT(B4, C4) and got the #NAME? error in J4 (my target cell).

What command do you use for division in an Excel spreadsheet?

[mack 44]

should be =(B4/C4)

[RadioGaGa 162]

should be =(B4/C4)

Thanks...that plus a little bit of extra thought on my part (god, my head hurts) made it work.

[Jason Harris 31]

For future uses, bear in mind you can have relative or absolute formulas.

A relative formula is essentially saying, "Divide the number that is in the cell over two and up one (B4) by the cell that is over one (C5)." If you were to copy the formula, B4 and C5 would change to B10 and C11, or even F23 and G24 if you moved the formula that far away.

An absolute formula says something like, "Divide the number that is over two and up one (B4) by this particular cell (A2) every time." If you copy this formula, B4 might change to B10 or D5 or N100, but they will always be divided by A2.

The way to make a cell become absolute in a formula is by putting a dollar sign in front of the cell. $A2 means keep the column constant (A), but make the row change in the same relation it currently has. A$2 means keep the row constant (2), but make the column change in the same relation it currently has. $A$2 means always use A2 in this formula.

[RadioGaGa 162]

For future uses, bear in mind you can have relative or absolute formulas.

A relative formula is essentially saying, "Divide the number that is in the cell over two and up one (B4) by the cell that is over one (C5)." If you were to copy the formula, B4 and C5 would change to B10 and C11, or even F23 and G24 if you moved the formula that far away.

An absolute formula says something like, "Divide the number that is over two and up one (B4) by this particular cell (A2) every time." If you copy this formula, B4 might change to B10 or D5 or N100, but they will always be divided by A2.

The way to make a cell become absolute in a formula is by putting a dollar sign in front of the cell. $A2 means keep the column constant (A), but make the row change in the same relation it currently has. A$2 means keep the row constant (2), but make the column change in the same relation it currently has. $A$2 means always use A2 in this formula.

Thanks...but I don't do a whole lot of hardcore calculating. Truth be told (insert mockery and laughter here)...I'm playing in a couple softball leagues this summer, and I just wanted to do a simple sheet to keep stats.

[Jason Harris 31]

Yes, but as you build your empire, you're going to need to keep track of where all the money's coming from. ;)