+ Reply to Thread
Results 1 to 4 of 4

Extrapolation

  1. #1
    Registered User
    Join Date
    05-28-2016
    Location
    South korea
    MS-Off Ver
    2013
    Posts
    9

    Extrapolation

    Hi all. I want to extrapolate the values using a formula in excel. The example sheet is attached. if the value in the column B i:e 'penetration depth' is less than 30, the value in the column A, i:e 'Blows' should be extrapolated for 30 with a maximum extrapolation value of 200. Can anyone please help? Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Extrapolation

    If I am understanding you correctly, try this in C2:

    =IF(B2<30,MIN(A2,200),"")

    If that doesn't give you the expected results, please update your sample from post #1 to include the expected results (manually entered).

  3. #3
    Registered User
    Join Date
    05-28-2016
    Location
    South korea
    MS-Off Ver
    2013
    Posts
    9

    Re: Extrapolation

    Thanks for your kind reply...The formula u suggested is just an if statement which returns the same value if the value in column C is less than 30. There is no extrapolation going on in this formula. for example in B10, the value is less than 30, but he formula returns the same value as A10 i:e 50. What i want is to extrapolate that A10 value (50) for a value of 30 because it is less than 30 in B10 (7). Thanks for your response again.

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Extrapolation

    Please follow the instructions from post #2 and update your sample to show the desired results of a working formula.

    Then I will be happy to create a formula to get you those results.

+ 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. Extrapolation graph
    By Mesut1337 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 05-12-2016, 08:50 AM
  2. Extrapolation Calculator
    By sinikiwep in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-11-2014, 09:27 AM
  3. Extrapolation- Temperature vs. Time
    By andrea salas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2012, 11:38 AM
  4. Extrapolation formula?
    By wonderdunder in forum Excel General
    Replies: 11
    Last Post: 03-25-2011, 11:03 AM
  5. Correcting an extrapolation macro
    By smurray444 in forum Excel General
    Replies: 2
    Last Post: 02-01-2006, 06:29 AM
  6. Automating Extrapolation
    By smurray444 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-29-2006, 09:20 AM
  7. Automating Extrapolation
    By smurray444 in forum Excel General
    Replies: 1
    Last Post: 01-29-2006, 09:09 AM

Tags for this Thread

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