I'm trying to set up a spreadsheet in excel to calculate my grades but the functions aren't all that great. I have a row of received marks, a row beneath that of the total possible marks, and then below that a row with their weights. So if I got 40 out of 50 on a midterm which was weighted to be 25% of the course I would have 40 50 25 So anyways, I'm trying to divide the first two number, and then multiply by the weight to get my actual mark. Then sum up all the weighted marks to get my final mark. But the problem is quotient only works with integers, so it doesn't carry fractions. Anyone know how to get around this? ie: 40/50 = 0.80 but it just returns 0. I want the 0.80 Or someone could write me a program in php or c++ to do it for me

Not sure why it's only returning 0, unless you have the cells formatted for text or something, or you have it set to not show any places after the decimal. Select "Cells" in the Format menu to check. You are a smart cookie, so I will assume you ruled that out. In any case, I just tried it on Excel for OS X, and it worked fine. I typed 40 in cell A1, 50 in cell A2, 25 in cell A3. Then I typed "=A1/A2*A3" (without the quotes) in cell A4, and it returned 20, which is what I expected. If I try just "=A1/A2" I get 0.8. I can't think of anything other than the cell formatting that would be screwing you up.

Apparently excel for windows sucks. (office XP) You have to use functions in windows, the A1/A2*A3 doesn't work, you need function operands. Like =QUOTIENT(A1, A2) Otherwise it wont work. And quotient is an integer function so it doesn't return decimals.