Results 1 to 3 of 3

Decreasing a cell value by one

Threaded View

tempcroupier Decreasing a cell value by one 07-27-2015, 02:00 PM
seasider89 Re: Decreasing a cell value... 07-27-2015, 02:16 PM
tempcroupier Re: Decreasing a cell value... 07-27-2015, 03:05 PM
  1. #1
    Registered User
    Join Date
    07-27-2015
    Location
    Singapoe
    MS-Off Ver
    Mac 2011
    Posts
    2

    Smile Decreasing a cell value by one

    Hi everyone:

    I'm a complete Excel idiot, I have no knowledge of macros or VBA, so please forgive me if there is an obvious answer to my question.

    I use a simple excel spreadsheet to manage the inventory of a business. I use it to track the current stock. So whenever there is a sale, I will manually reduce the quantity of stock.

    What I am trying to do in my spreadsheet (which I've attached a small screenshot if it helps anyone) is to be able to use a keystroke to increase or decrease the value of a cell by one. I.e. pressing "," will increase the number in a highlighted/selected cell by one and pressing "." will decrease the number in a highlighted/selected cell by one.

    At the moment I am re-inputting the values after doing the math in my head. So when a customer buys 7 pants, I'll have to calculate in my head and then key in the new value in the cell. This is time consuming and also makes it open to mistakes. Is there a simple way to do this? Can anyone help me?

    Thank you very much in advance!!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Increase one cell by decreasing another.
    By Markiemark101 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-16-2014, 04:25 AM
  2. Formula for decreasing value.
    By omnifold in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-22-2013, 03:16 PM
  3. Decreasing numbers in cell
    By angelboy in forum Excel General
    Replies: 8
    Last Post: 01-23-2010, 10:32 AM
  4. increasing/decreasing by one
    By pagheca in forum Excel General
    Replies: 2
    Last Post: 05-14-2008, 04:57 AM
  5. increasing/decreasing; decreasing rate - problem
    By vasyuta in forum Excel General
    Replies: 0
    Last Post: 08-23-2006, 05:26 PM
  6. Replies: 8
    Last Post: 04-21-2006, 03:59 PM
  7. increasing and decreasing a value in a cell
    By cwal in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-14-2006, 01:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1