+ Reply to Thread
Results 1 to 2 of 2

Intersecting numbers

  1. #1
    Registered User
    Join Date
    05-27-2017
    Location
    BC. Canada
    MS-Off Ver
    MS Office 2010
    Posts
    1

    Intersecting numbers

    For lack of a better description I am looking for a way to calculate how long it will take 2 increasing numbers to intersect each other or overtake.

    For example

    A1 = 100 and increases by 1 daily
    B1 = 1 and increases by 3 daily

    Day 1 - A1 = 100; B1 = 1
    Day 2 - A1 = 101; B1 = 4
    Day 3 - A1 = 102; B1 = 7
    Day 4 - A1 = 103; B1 = 10....

    I am looking for how many "days" it will take for B1 >= A1 to occur.

    The only work around I have was to make a table where A1 was 100 and A2 was "A1+1"... B1 was 1 and B2 was "B1+3". Added some if statements so when column B was >= column A they stopped increasing then just did a countif function to find out how many "days" occurred.

    Does anyone have a more simple solution?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,874

    Re: Intersecting numbers

    Are you allowed to use simple algebra?

    a is the value in A1, b is the value in B1, d is the day number.
    a=100+1*(d-1)
    b=1+3*(d-1)
    Set a=b and solve for d.

    If you need an algebra refresher, I like this one: http://www.purplemath.com/modules/solvelin.htm
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Intersecting value of graph
    By sac0011 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 01-15-2014, 01:04 AM
  2. intersecting value of graph
    By sac0011 in forum Excel General
    Replies: 1
    Last Post: 01-04-2014, 12:16 PM
  3. Using VBA to name intersecting ranges
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2012, 02:03 AM
  4. Display Intersecting Cell
    By armaank in forum Excel General
    Replies: 4
    Last Post: 01-26-2011, 12:53 PM
  5. Filter By Intersecting Columns
    By dpcdpc11 in forum Excel General
    Replies: 4
    Last Post: 05-06-2010, 04:33 PM
  6. Table of intersecting data
    By HBM in forum Excel General
    Replies: 2
    Last Post: 08-14-2009, 09:59 AM
  7. Intersecting--Maybe?
    By joone in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2007, 03:40 AM
  8. Intersecting Data
    By kojak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-02-2006, 11:40 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