[Cage]

I'm having trouble finishing this chart on excel and I have a few questions. Hopefully some of you can help.

1. Why does B6 show up as 9000%? I'm trying to type in "90", but it shows up as that when I enter it.
2. Why is it when I type a total into C3, it shows up as a date?
3. How do I get the total and average on side, as a collum?

(Screenshot)
http://img215.imageshack.us/my.php?image=exceljf3.jpg

Thanks!

[Jeysie]

Originally Posted by Cage

1. Why does B6 show up as 9000%? I'm trying to type in "90", but it shows up as that when I enter it.
2. Why is it when I type a total into C3, it shows up as a date?

I would check the formatting for both of these. (Highlight the cell, then on the menu Format>Cells>Number) At first glance, it looks like Excel is changing your input to fit Percentage and Date number formatting, respectively.

Originally Posted by Cage

3. How do I get the total and average on side, as a collum?

For totals, type this into the Row 3 "Total" cell:

=SUM(B3:J3)

Then copy that Total cell and paste into each other Total cell in turn... Excel should auto-change the row numbers for you.

You could also highlight that Total cell, hover over the lower right corner edge until you see a black cross, click, drag it down until every empty cell is highlighted, then let go.

For averages the formula is as follows:

=AVERAGE(B3:J3)

Same instructions for populating the other rows.

Hopefully this helps you out, and all those hours creating D&D character sheets in Excel proves to be useful after all.

Peace & Luv, Liz

[Giligan]

Microsoft excel? Don't those two words completely contradict each other?

[Melanie68]

Originally Posted by Giligan

Microsoft excel? Don't those two words completely contradict each other?

Can we not turn this into a rant against Microsoft, please?

[Cage]

Originally Posted by Jeysie

I would check the formatting for both of these. (Highlight the cell, then on the menu Format>Cells>Number) At first glance, it looks like Excel is changing your input to fit Percentage and Date number formatting, respectively.



For totals, type this into the Row 3 "Total" cell:

=SUM(B3:J3)

Then copy that Total cell and paste into each other Total cell in turn... Excel should auto-change the row numbers for you.

You could also highlight that Total cell, hover over the lower right corner edge until you see a black cross, click, drag it down until every empty cell is highlighted, then let go.

For averages the formula is as follows:

=AVERAGE(B3:J3)

Same instructions for populating the other rows.

Hopefully this helps you out, and all those hours creating D&D character sheets in Excel proves to be useful after all.

Peace & Luv, Liz

You're a saint. Thank you.

[Jeysie]

No problem, glad to help.

Peace & Luv, Liz