Page 3 of 3 FirstFirst 123
Results 61 to 80 of 80

Thread: Excel Help

  1. #61
    Banned marooko's Avatar
    Join Date
    May 2007
    Location
    In your mouth!
    Posts
    19,687

    Default Re: Excel Help

    =B12-C12-D12

    But when I change anything in those cells, nothing happens in the cell containing the formula. This has never happened to me before, why now? Simple ass formula. WTF?!

  2. #62
    Coachella Junkie PlayaDelWes's Avatar
    Join Date
    Mar 2007
    Location
    The Sprawl
    Posts
    7,358

    Default Re: Excel Help

    Sometimes (not sure why) the setting for Automatic Workbook Calbulation changes Manual. Go into Excel Settings -> Formulas -> Calculation Options and make the change back.

    Another reason for this is the number format for the cells. If it's set to "Text" for some reason, it might not calculate.
    Quote Originally Posted by dj12inches View Post
    What makes me qualified? I've watched EVERY fucking episode of American Idol, and every single episode of The Voice...Forget that I won departmental music awards when I was in the 8th grade choir.

  3. #63
    Banned marooko's Avatar
    Join Date
    May 2007
    Location
    In your mouth!
    Posts
    19,687

    Default Re: Excel Help

    Settings. Thank you. Never changed anything there, didn't think to look.

  4. #64

    Default Re: Excel Help

    God you're dumb Marooko.
    Formerly Riggins33
    Formerly Profchaos

    Coachella 2006 2007 2008 2009 2010 2011 2012 w2 2013 w1

  5. #65
    Banned marooko's Avatar
    Join Date
    May 2007
    Location
    In your mouth!
    Posts
    19,687

    Default Re: Excel Help

    Everyone knows the settings will change on their own except me. I should wear a dunce cap for that one.

  6. #66
    Coachella Junkie fatbastard's Avatar
    Join Date
    Nov 2006
    Location
    Pasadena
    Posts
    12,284

    Default Re: Excel Help

    Maybe you got a bad batch of Excel
    Whiskey Sour

    2 oz blended whiskey
    Juice of 1/2 lemon
    1/2 tsp powdered sugar
    1 cherry
    1/2 slice lemon

    Shake blended whiskey, juice of lemon, and powdered sugar with ice and strain into a whiskey sour glass. Decorate with the half-slice of lemon, top with the cherry, and serve.

  7. #67
    Coachella Junkie jackstraw94086's Avatar
    Join Date
    Dec 2006
    Posts
    8,413

    Default Re: Excel Help

    It can happen when you open a file from someone else who had their calcs set to manual.

  8. #68
    old school ThatGirl's Avatar
    Join Date
    Feb 2011
    Location
    Canada
    Posts
    4,176

    Default Re: Excel Help

    In a beginner level one day Excel 2010 course I took voluntarily to better navigate budget Spreadsheets we use at work, the instructor gave us the task of trying to create this formula. How the fuck can this be beginner level? Tomorrow is the advanced course. Am I crazy or is the instructor totally fucked?

    ="("&LEFT(H1,3)&") "&MID(H1,4,3)&"-"&RIGHT(H1,4)
    Quote Originally Posted by M Sparks View Post
    It's all riding on this. You've got big dreams to ride to the top of the Flash Mob world. Well internet fame costs. And right now is when you start paying for it...in sweat.
    Quote Originally Posted by TomAz View Post
    hey. get your own colonoscopy thread, bitch.

  9. #69
    Coachella Junkie locachica73's Avatar
    Join Date
    Apr 2008
    Location
    Phoenix
    Posts
    13,761

    Default Re: Excel Help

    I consider myself pretty good with excel, but have never had to do a formula like that. I did when I took lotus123. I tried to copy your formula into excel to see what it did, and it froze my program. Your instructor is totally fucked. :-/
    Quote Originally Posted by SlowMotionApocalypse View Post
    I have snuck in weapons before
    Quote Originally Posted by TomAz View Post
    A butt plug is not a weapon.

  10. #70
    Member insbordnat's Avatar
    Join Date
    Jan 2007
    Location
    In a blazing inferno
    Posts
    1,826

    Default Re: Excel Help

    That's a fairly basic formula, but different people have different excel needs. I'm often times dumping large amounts of data and doing vlookups, pivots, etc. and in order to "mask" the data I need to use those referential formulas.

    I don't think your instructor is that off base. More advanced will probably be pivots, vlookups, match/index, etc. I've been using excel for over 10 years on a heavy daily basis and I still consider myself an intermediate user. Most advanced users I know are creating VBA code and other wacky shit.
    northside groove...southside groove....eastside groove...westside groove

  11. #71
    Coachella Junkie locachica73's Avatar
    Join Date
    Apr 2008
    Location
    Phoenix
    Posts
    13,761

    Default Re: Excel Help

    The basic class I took was mainly just how to navigate around, how to use the basic point and click functions in the tool bar and how to format. Even the intermediate class was somewhat basic teaching filters, graphs, etc. I use to know how to use pivot tables & macros, but haven't had to use them in my career so I have lost the knowledge along the way. Sadly, I can wow my bosses by my ability to drag and drop, if I could show them how to use a pivot table they would probably think I am a sorcerer.
    Quote Originally Posted by SlowMotionApocalypse View Post
    I have snuck in weapons before
    Quote Originally Posted by TomAz View Post
    A butt plug is not a weapon.

  12. #72
    old school ThatGirl's Avatar
    Join Date
    Feb 2011
    Location
    Canada
    Posts
    4,176

    Default Re: Excel Help

    I haven't learned filters but we did links, charting, formatting, protecting, a bunch of shit. Need more course work. The instructor was a dip shit.
    Quote Originally Posted by M Sparks View Post
    It's all riding on this. You've got big dreams to ride to the top of the Flash Mob world. Well internet fame costs. And right now is when you start paying for it...in sweat.
    Quote Originally Posted by TomAz View Post
    hey. get your own colonoscopy thread, bitch.

  13. #73
    Coachella Junkie locachica73's Avatar
    Join Date
    Apr 2008
    Location
    Phoenix
    Posts
    13,761

    Default Re: Excel Help

    Filters are probably my favorite thing about excel. I work for a company that loves logs. We joke that we need to have a log to track all of the logs. Filters are awesome when companies want to keep 5,000 lines of data in the same spreadsheet.
    Quote Originally Posted by SlowMotionApocalypse View Post
    I have snuck in weapons before
    Quote Originally Posted by TomAz View Post
    A butt plug is not a weapon.

  14. #74
    Coachella Junkie shakermaker113's Avatar
    Join Date
    Jan 2007
    Location
    san francisco
    Posts
    14,840

    Default Re: Excel Help

    That formula translates a phone number into the standard presentation. If that looks insane to you you've got a long way to go.

  15. #75
    Coachella Junkie locachica73's Avatar
    Join Date
    Apr 2008
    Location
    Phoenix
    Posts
    13,761

    Default Re: Excel Help

    Why wouldn't you just format the cell to a phone number? That is a whole lot of extra typing to do what can be done with 2 clicks of the mouse. Was his mouse dead?
    Quote Originally Posted by SlowMotionApocalypse View Post
    I have snuck in weapons before
    Quote Originally Posted by TomAz View Post
    A butt plug is not a weapon.

  16. #76
    old school ThatGirl's Avatar
    Join Date
    Feb 2011
    Location
    Canada
    Posts
    4,176

    Default Re: Excel Help

    Quote Originally Posted by shakermaker113 View Post
    That formula translates a phone number into the standard presentation. If that looks insane to you you've got a long way to go.
    Yes this is what it was supposed to do. But it was an entry level class, and a friend of mine that is an Excel expert said she'd never seen it either. I am fully aware that I have a lot to learn but I wasn't the only one in the class that was struggling with this, as it was one of the first formulas we created.


    Quote Originally Posted by locachica73 View Post
    Why wouldn't you just format the cell to a phone number? That is a whole lot of extra typing to do what can be done with 2 clicks of the mouse. Was his mouse dead?
    He didn't tell us this shortcut, but he was a pretty old guy, a computer science type math geek, seemingly more interested in doing fancy arithmetic calculations than teaching us how to use this application in a practical way.
    Quote Originally Posted by M Sparks View Post
    It's all riding on this. You've got big dreams to ride to the top of the Flash Mob world. Well internet fame costs. And right now is when you start paying for it...in sweat.
    Quote Originally Posted by TomAz View Post
    hey. get your own colonoscopy thread, bitch.

  17. #77
    Member insbordnat's Avatar
    Join Date
    Jan 2007
    Location
    In a blazing inferno
    Posts
    1,826

    Default Re: Excel Help

    I think he was just trying to show the left/right/mid formulas in a useful way. There's a lot of ways you can use them and the "&" to concatenate data without using CONCATENATE.
    northside groove...southside groove....eastside groove...westside groove

  18. #78
    old school ThatGirl's Avatar
    Join Date
    Feb 2011
    Location
    Canada
    Posts
    4,176

    Default Re: Excel Help

    Yeah. Every time he said that word I think I had a little stroke.
    Quote Originally Posted by M Sparks View Post
    It's all riding on this. You've got big dreams to ride to the top of the Flash Mob world. Well internet fame costs. And right now is when you start paying for it...in sweat.
    Quote Originally Posted by TomAz View Post
    hey. get your own colonoscopy thread, bitch.

  19. #79
    Coachella Junkie shakermaker113's Avatar
    Join Date
    Jan 2007
    Location
    san francisco
    Posts
    14,840

    Default Re: Excel Help

    I'm not sure this class is for you.

  20. #80
    old school ThatGirl's Avatar
    Join Date
    Feb 2011
    Location
    Canada
    Posts
    4,176

    Default Re: Excel Help

    It was only two days and I finished it, but I need to take the advanced course next month. I just hope this same guy isn't the instructor.
    Quote Originally Posted by M Sparks View Post
    It's all riding on this. You've got big dreams to ride to the top of the Flash Mob world. Well internet fame costs. And right now is when you start paying for it...in sweat.
    Quote Originally Posted by TomAz View Post
    hey. get your own colonoscopy thread, bitch.

Similar Threads

  1. excel schedule
    By rks1129 in forum Misc. Babble
    Replies: 5
    Last Post: 04-23-2008, 08:41 AM
  2. Another Excel Spreadsheet
    By sddoctor in forum Line Up/Artists
    Replies: 2
    Last Post: 04-24-2007, 12:30 PM
  3. excel set times sheets?
    By psychic friend in forum Music Lounge
    Replies: 72
    Last Post: 02-28-2007, 07:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •