Excel Problems

Discussion in 'OT Technology' started by SouthernGirl117, Jul 13, 2008.

Thread Status:
Not open for further replies.
  1. SouthernGirl117

    SouthernGirl117 New Member

    Joined:
    Feb 17, 2007
    Messages:
    1,026
    Likes Received:
    0
    Location:
    Charlotte, N.C.
    I'm taking an online computer class & I'll admit upfront that I am not very good with Excel. (Obviously...that's why I'm posting this thread.) I would appreciate any help someone could give me. I'm stuck on an assignment (the hardest & last assignment for the Excel section) for this class & have been beating my head on my desk for the last hour & a half. Anyway...my problem is when I'm trying to enter in formulas. Ex: (b2 * (b3 / (1 - b6))...I've tried typing the formula WITH spaces & WITHOUT...about 900 times! WHY is nothing showing up in my totals?! Does it have something to do with absolute cell references or relative cell references or some shit?! I have re-read that section in the chapter about 5 times. I'm STUCK & about to give up & email my instructor or a fellow classmate for help. Nothing like procrastinating! Thanks in advance for your help! I would really appreciate it. :rant:

    P.S. Thanks Eric for suggesting I try for help here. I owe ya 1. :naughty:
     
  2. Slick26

    Slick26 Gun|Bike|Cigar|PS3|Beer |Whisky|Night Crew

    Joined:
    Jul 28, 2006
    Messages:
    47,998
    Likes Received:
    0
    Location:
    Mini Soda
  3. SouthernGirl117

    SouthernGirl117 New Member

    Joined:
    Feb 17, 2007
    Messages:
    1,026
    Likes Received:
    0
    Location:
    Charlotte, N.C.
    Keep that up & I'll take it back....
     
  4. SouthernGirl117

    SouthernGirl117 New Member

    Joined:
    Feb 17, 2007
    Messages:
    1,026
    Likes Received:
    0
    Location:
    Charlotte, N.C.
    P.S. People like you who are just going to laugh or make fun of my problem, need not waste their fucking time or mine. 'Kthanks.
     
  5. Sailor Jerry

    Sailor Jerry OT Supporter

    Joined:
    Nov 13, 2007
    Messages:
    35,173
    Likes Received:
    8
    Location:
    Dirtona Beach
    No spaces and put an = behind it.

    At least I think that's how it works. I'm in Ubuntu and don't feel like rebooting into Windows to try it.
     
  6. Doomsday

    Doomsday XXX

    Joined:
    Mar 14, 2000
    Messages:
    14,902
    Likes Received:
    0
    Location:
    Minnesota
    =(B2 * (B3 / (1 - B6)))
     
  7. trouphaz

    trouphaz New Member

    Joined:
    Sep 22, 2003
    Messages:
    2,666
    Likes Received:
    0
    what does show up? do you get garbage output? does it give a number, but just the wrong one?

    as far as i can tell, the contents of the cell should be:
    =b2*(b3/(1-b6))

    in your post you had 3 ( and only 2 ) plus you didn't have the = at the beginning.
     
  8. Doomsday

    Doomsday XXX

    Joined:
    Mar 14, 2000
    Messages:
    14,902
    Likes Received:
    0
    Location:
    Minnesota
    btw, "do my homework" is not allowed on this sub forum
    nudes?
     
  9. Slick26

    Slick26 Gun|Bike|Cigar|PS3|Beer |Whisky|Night Crew

    Joined:
    Jul 28, 2006
    Messages:
    47,998
    Likes Received:
    0
    Location:
    Mini Soda
    :bowdown: finally someone said it. I was waiting for it.
     
  10. SouthernGirl117

    SouthernGirl117 New Member

    Joined:
    Feb 17, 2007
    Messages:
    1,026
    Likes Received:
    0
    Location:
    Charlotte, N.C.
    I forgot to type the = in my post, but I HAVE been including it in the formula for the assignment. Wow. I have no idea how it worked that time, but it did! It looks like you typed the whole formula in without spaces & I swear I tried it like that (& with spaces) at least 100 times! Thank you so much for your help!!! I really do appreciate it. Now I can only hope the rest of the assignment goes smoothly. I still don't know why it wasn't working for me before. Oh & I wasn't getting garbage output; nothing was happening; no #s, no totals, nothing...Hey man. Thanks again! :)
     
  11. trouphaz

    trouphaz New Member

    Joined:
    Sep 22, 2003
    Messages:
    2,666
    Likes Received:
    0
    i wouldn't say this is a "do my homework" question. this is someone who is obviously trying to get it done on her own, but is stuck and is asking for assistance. all either of us gave her was add or take away a parenthesis and add an equal sign.

    now, how about them nudes? lollers
     
  12. Slick26

    Slick26 Gun|Bike|Cigar|PS3|Beer |Whisky|Night Crew

    Joined:
    Jul 28, 2006
    Messages:
    47,998
    Likes Received:
    0
    Location:
    Mini Soda
    Better send him noodz... you know, to show your gratitude.
     
  13. Slick26

    Slick26 Gun|Bike|Cigar|PS3|Beer |Whisky|Night Crew

    Joined:
    Jul 28, 2006
    Messages:
    47,998
    Likes Received:
    0
    Location:
    Mini Soda
    Fail.
    |
    |
    |
    |
    |
    |
    |
    \/
     
  14. SouthernGirl117

    SouthernGirl117 New Member

    Joined:
    Feb 17, 2007
    Messages:
    1,026
    Likes Received:
    0
    Location:
    Charlotte, N.C.
    [quote=trouphaz;i wouldn't say this is a "do my homework" question. this is someone who is obviously trying to get it done on her own, but is stuck and is asking for assistance. all either of us gave her was add or take away a parenthesis and add an equal sign.

    . The = equal sign was never a problem. I always had it there. Apparently it was a problem with the spacing, which I tried several different ways before. I dunno. But thanks again!!!!
     
  15. SouthernGirl117

    SouthernGirl117 New Member

    Joined:
    Feb 17, 2007
    Messages:
    1,026
    Likes Received:
    0
    Location:
    Charlotte, N.C.
    Fuck you. Doncare. Not important. I got my point across.
     
  16. Slick26

    Slick26 Gun|Bike|Cigar|PS3|Beer |Whisky|Night Crew

    Joined:
    Jul 28, 2006
    Messages:
    47,998
    Likes Received:
    0
    Location:
    Mini Soda
    Nudes?
     
  17. SouthernGirl117

    SouthernGirl117 New Member

    Joined:
    Feb 17, 2007
    Messages:
    1,026
    Likes Received:
    0
    Location:
    Charlotte, N.C.
    :rofl: You first.
     
  18. EkriirkE

    EkriirkE Zika Xenu OT Supporter

    Joined:
    Jan 11, 2004
    Messages:
    14,799
    Likes Received:
    0
    Location:
    Dublin & San Francisco, CA
    do it :squint:
     
  19. Slick26

    Slick26 Gun|Bike|Cigar|PS3|Beer |Whisky|Night Crew

    Joined:
    Jul 28, 2006
    Messages:
    47,998
    Likes Received:
    0
    Location:
    Mini Soda
    I couldn't be so cruel.
     
  20. SouthernGirl117

    SouthernGirl117 New Member

    Joined:
    Feb 17, 2007
    Messages:
    1,026
    Likes Received:
    0
    Location:
    Charlotte, N.C.
    Ok. The real thing will do. I think. :mamoru:
     
  21. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    It wasn't the spacing - Excel doesn't care about how many spaces you use.
     
  22. tyrionlannister

    tyrionlannister New Member

    Joined:
    Jun 13, 2006
    Messages:
    710
    Likes Received:
    0
    Location:
    New York
    For each open parenthesis, you need a corresponding close parenthesis.
     
  23. SouthernGirl117

    SouthernGirl117 New Member

    Joined:
    Feb 17, 2007
    Messages:
    1,026
    Likes Received:
    0
    Location:
    Charlotte, N.C.
    Actually, it was...But I got it worked out.
     
  24. SouthernGirl117

    SouthernGirl117 New Member

    Joined:
    Feb 17, 2007
    Messages:
    1,026
    Likes Received:
    0
    Location:
    Charlotte, N.C.
    Thanks. :)
     
  25. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    I'll make a correction then, every copy of Excel but yours doesn't care about the spacing. You should feel special!
     
Thread Status:
Not open for further replies.

Share This Page