+ Reply to Thread
Results 1 to 4 of 4

Incremental changes

Hybrid View

  1. 08-16-2018, 12:00 PM #1
    pjly29
    pjly29 is offline
    Registered User
    Join Date
    08-16-2018
    Location
    Cape Cod, MA
    MS-Off Ver
    Office 2016
    Posts
    2

    Incremental changes

    Hi Everyone,

    I'm new here, and have been taking a course at an online college for management through excel spreadsheets.
    One issue I have come across is decreasing one cell based on increases in another.

    For example, cell B2 is MPH at 55.6mph. Cell C2 is MPG at 6.5.
    I am trying to decrease by X based on every +1 increase of cell B2.

    i had used an if(and) function, and was able to subtract once, but can not figure out how to continue the decrease based up B2 increases.

    Thanks in advance!!!!!

    Patrick
    Reply With QuoteRegister To Reply
  2. 08-16-2018, 12:18 PM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,078

    Re: Incremental changes

    "I am trying to decrease by X"

    What are you trying to decrease ? The value in C2 ? Or something else ?

    If it's C2 you want to decrease this can be performed by a calculation given those start values.

    in C2

    =6.5-(B2-55.6)*D1

    where D1 is your "x" amount, the amount you want to decrease C2 by.
    Last edited by Special-K; 08-16-2018 at 12:21 PM.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 08-16-2018, 12:41 PM #3
    pjly29
    pjly29 is offline
    Registered User
    Join Date
    08-16-2018
    Location
    Cape Cod, MA
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Incremental changes

    Hi,

    Thanks!

    Yes I am trying to decrease C2 by .14 for every 1 increase in B2.

    Creating that formula worked! Thank you so much! I was stumped since last night!
    Last edited by pjly29; 08-16-2018 at 12:50 PM.
    Reply With QuoteRegister To Reply
  4. 08-17-2018, 04:35 AM #4
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,078

    Re: Incremental changes

    Yes C2 will stay the same if B2 doesn't increase.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Incremental List
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-27-2015, 04:19 AM
  2. [SOLVED] Incremental Rows
    By mikepacman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-28-2014, 09:42 AM
  3. Incremental Division [Almost there]
    By kgibson20 in forum Excel General
    Replies: 6
    Last Post: 02-28-2012, 01:08 PM
  4. Incremental issue
    By chweiny33 in forum Excel General
    Replies: 1
    Last Post: 01-11-2012, 12:49 PM
  5. [SOLVED] Incremental Numbering
    By fastcar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-11-2006, 10:15 PM
  6. [SOLVED] incremental counter
    By cynthiabryant in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-03-2006, 12:20 PM
  7. incremental counter
    By cynthiabryant in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-03-2006, 11:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1