Results 1 to 4 of 4

Auto sum of two or more cells that will limit the result to one digit.

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2017
    Location
    Poipet, Cambodia
    MS-Off Ver
    MS Office 2007
    Posts
    6

    Auto sum of two or more cells that will limit the result to one digit.

    Hello guys can you help me Im new on using the excel as for it i was trying to make a simulation of likes of baccarat card games which will have cards value and Im making a computation for excel on it is there a way i can declare value of 10 to 0. As for the result from the column F it auto sum the values from column B and D same from column G it auto sum the values from column C and E. I just want to limit the sum, which will give me results from 0 to 9 only even for sample the value of 2 cells will sum up 10, 20, 30 it will result to 0 and if it is 11, 21 it will only result 1 which will be only in one digit.

    Thank You very much.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 17
    Last Post: 02-02-2016, 05:05 AM
  2. Populating of auto-filtered cells stops halfway down - is this memory limit?
    By fallwire in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2015, 01:47 AM
  3. Replies: 29
    Last Post: 01-09-2015, 05:39 PM
  4. Help: How do I have a drop-down cell auto-populate other cells based on result?
    By benjamin.glover in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-15-2014, 01:46 PM
  5. Replies: 2
    Last Post: 06-17-2010, 08:36 PM
  6. limit digit in cell
    By fun123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-27-2009, 12:37 PM
  7. [SOLVED] Can I change the 15-digit limit in Excel for numbers ?
    By Johan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2005, 10:06 AM

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