Portal   Forum   Members   Market   Gallery   Events

Help with office functions

Discussion in 'Help Forum' started by cowofwar, Apr 7, 2003.

  1. cowofwar

    cowofwar Peasant

    Joined:
    Jun 14, 2000
    Messages:
    13,721
    Likes Received:
    18
    Market Rating:
    0
    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 :)
     
  2. Lurk

    Lurk Peasant and Donator

    Joined:
    Jul 19, 2000
    Messages:
    2,586
    Likes Received:
    47
    Market Rating:
    0
    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.
     
  3. cowofwar

    cowofwar Peasant

    Joined:
    Jun 14, 2000
    Messages:
    13,721
    Likes Received:
    18
    Market Rating:
    0
    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.
     
  4. Elbereth

    Elbereth MSC Commander and Donator

    Joined:
    Jun 17, 2000
    Messages:
    3,356
    Likes Received:
    14
    Market Rating:
    0
    Time for my stock reply - Use a Mac!

    ;)


    Sorry, I can't be any real help.
     
  5. Lurk

    Lurk Peasant and Donator

    Joined:
    Jul 19, 2000
    Messages:
    2,586
    Likes Received:
    47
    Market Rating:
    0
    Now that's bizarre. The A1/A2 works in Office 97 for Windows, which is what I have at work. :confused:
     
  6. cowofwar

    cowofwar Peasant

    Joined:
    Jun 14, 2000
    Messages:
    13,721
    Likes Received:
    18
    Market Rating:
    0
    Got it working, your way works, Lurk, but you need to put an = in front.

    Like =A1/A2
     
  7. Lurk

    Lurk Peasant and Donator

    Joined:
    Jul 19, 2000
    Messages:
    2,586
    Likes Received:
    47
    Market Rating:
    0

    Isn't that what I said? :p


     
  8. cowofwar

    cowofwar Peasant

    Joined:
    Jun 14, 2000
    Messages:
    13,721
    Likes Received:
    18
    Market Rating:
    0
    Guess I can't read :(
     

Hitometer: 53,943,818 since 1995