Results 1 to 5 of 5

Subtract 20 repeatedly from an original value until the value reaches zero

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2018
    Location
    canada
    MS-Off Ver
    2016
    Posts
    1

    Subtract 20 repeatedly from an original value until the value reaches zero

    I am a professed excel noob and so I need help writing this function. I need to write a function where a column of values will subtract from an original value until the value reaches zero.

    If my original value is 125, I need the following table to look like this

    B1 20
    B2 20
    B3 20
    B4 20
    B5 20
    B6 20
    B7 5

    I need the function to be generic so that I can start with any original value and the function will show 20 in the column cells until the value reaches less than 20 in the final cell.

    hope this makes sense.
    Last edited by excel_noob14; 02-24-2018 at 11:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Subtract Max Until Balance Reaches Zero
    By FinanceGQ in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-25-2016, 02:15 PM
  2. Formula -- subtract date, delete original column?
    By mlengel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-14-2013, 12:58 PM
  3. [SOLVED] How to subtract multiple cells from a cell and report soldout when main number reaches 0
    By QuietForce in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-02-2012, 01:43 AM
  4. If Sat subtract one day, if Sunday subtract tow days
    By Wskip49 in forum Excel General
    Replies: 3
    Last Post: 06-30-2012, 03:35 PM
  5. Repeatedly Using 'ShowAllData'
    By JONNY981 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2009, 11:24 AM
  6. keeping original sheets as original
    By stevesunfold in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-04-2008, 05:33 AM
  7. Replies: 1
    Last Post: 08-15-2005, 06:05 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