smart excel question - only for smart user

Discussion in 'Waffle' started by logikz, May 21, 2008.

  1. logikz

    logikz I Am Not The King Staff Member

    Joined:
    Feb 8, 2002
    Messages:
    10,556
    Likes Received:
    2,520
    Location:
    www.easternpromiseaudio.com
    i need a forumla that does +1 in a cell, beginning from 0 regardless of what number pressed on keypad?
     
  2. safety

    safety double safety

    Joined:
    Mar 15, 2007
    Messages:
    6,368
    Likes Received:
    29
    Location:
    raglan, nz
    so you want excel to add one to whatever number you type? are you trying to fuck with someone or is there a reason you can't just type the actual number you want in there?
     
  3. Greg P

    Greg P Active Member

    Joined:
    Jan 16, 2008
    Messages:
    2,174
    Likes Received:
    1
    Just go to the cell next to where you're going to enter the number, then type in the box at the top "=(click on the cell where the number is)+1

    Does that do it for ya?
     
  4. SIRUS

    SIRUS 変なひと

    Joined:
    Feb 16, 2007
    Messages:
    5,158
    Likes Received:
    874
    I WAS LYING TO MYSELF BY SIMPLY OPENING THIS THREAD
     
  5. Dustek

    Dustek Finished the PhD

    Joined:
    Oct 18, 2004
    Messages:
    5,914
    Likes Received:
    15
    Location:
    London on the Wisla
    I assume you want to fuck with someone.

    Logikz, how good is your command of macros?

    For it not be obvious what is going on you're going to have make quite a perverse macro which automatically loads into all spreadsheets. I think I could explain how to do this but it would take a shitload of time.