+ Reply to Thread
Results 1 to 2 of 2

Formula for a reaction when another column hits a certain value.

  1. #1
    Registered User
    Join Date
    05-27-2017
    Location
    United Kingdom
    MS-Off Ver
    2016
    Posts
    1

    Formula for a reaction when another column hits a certain value.

    Hi, I was wondering if there is such a thing as a formula that adds a value to it's own cell when the cell adjacent to it has reached a certain value.

    My best example of this would be: I buy one shop, however I spend the profit from this shop to buy another shop, and so on. In one column I would have the amount of shops I own and in the next the profit, when the profit hit $50,000 it would automatically make the number of shops owned cell adjacent to it go up by one.

    Thanks

    P.S. I don't own or plan on owning any shops

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Formula for a reaction when another column hits a certain value.

    No, you cannot have a cell with a static number and a formula at the same time. It's one or the other.

    The only way to make a cell with a static number change would be thru VBA.
    HTH
    Regards, Jeff

+ 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. Sum a column until it hits a certain value then stop
    By truxhavenx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2015, 11:19 AM
  2. [SOLVED] repeating macro column by column until it hits a blank
    By bardobhb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2014, 07:05 PM
  3. Formula to remove figures from a line when a certain date hits
    By McQLon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2014, 07:27 AM
  4. Need help: Ruingn formula until row sum hits a maximum
    By sandik in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2013, 09:30 PM
  5. Search and highlight hits only in Column C
    By kenelder in forum Excel General
    Replies: 5
    Last Post: 06-12-2013, 11:44 AM
  6. Replies: 7
    Last Post: 11-02-2011, 08:22 PM
  7. hyperlink to hits from excel formula
    By pinkstonm in forum Excel General
    Replies: 0
    Last Post: 06-06-2011, 01:47 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