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

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).

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.

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.