Results 1 to 6 of 6

Want to limit amount taken out by a cell to a set amount. Still looking for help with this

Threaded View

RVT Want to limit amount taken... 11-08-2013, 12:08 PM
aganesan99 Re: Columns B - G take 100 %... 11-08-2013, 12:15 PM
RVT Re: Columns B - G take 100 %... 11-08-2013, 01:48 PM
aganesan99 Re: Columns B - G take 100 %... 11-11-2013, 04:31 AM
ragulduy Re: Columns B - G take 100 %... 11-08-2013, 12:15 PM
RVT Re: Columns B - G take 100 %... 11-08-2013, 01:47 PM
  1. #1
    Registered User
    Join Date
    11-04-2013
    Location
    Reno Nevada
    MS-Off Ver
    Excel 2007
    Posts
    31

    Want to limit amount taken out by a cell to a set amount. Still looking for help with this

    Hello,

    Making a new spreadsheet.

    Would you please let me know how I can make a spreadsheet do this.

    Nothing that I have tried is working so far.

    A = $ 100
    B = takes 100 % of the amount in A up to $ 40
    C = takes 100 % of the amount in A up to $ 40
    D = takes 100 % of the amount in A up to $ 20
    E = takes 100 % of the amount in A up to $ 20 but does not post a value in the cell as there is nothing left of the $ 100.
    etc.

    Thank you,
    Richard Todd
    Last edited by RVT; 11-08-2013 at 03:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to sum every x amount of columns?
    By underrated209 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-16-2013, 12:52 AM
  2. [SOLVED] Need a formula for an amount in a column that is just 2 columns subracted from one another
    By laurabach in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2013, 11:17 PM
  3. [SOLVED] In pivot match vertical row amount with the horizontal column -amount and highlight that
    By Goku in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2013, 02:04 AM
  4. Replies: 1
    Last Post: 08-24-2012, 03:18 PM
  5. Replies: 5
    Last Post: 09-30-2010, 08:02 PM

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