Multiple logicals

Hey guys,
I have a new problem. I tryed solving it with logicals, but its to complex for that. What I have are 2 collumns; one with depth and one with an inclination. The inclination is 0 at start but starts building at a certain depth given in a cell. So when the depth cell is at that depth I want the inclination cell to start building up. Lets say cell is B14, so value is B13+0.75. 0.75 is also a cell which you can refer to. I want this to keep building until another value of depth buy which I want the inclination to stop and stay the same as the previous value, so value of B200 = B199.

Can anybody help?

So essentially you want the inclination to increase only while the depth is between two values?

If column A has your depths and B has your inclination, with 0 values in A1 and B1, this formula copied from B2 down the column will only increase the inclination while the depth is between 30 and 70:


=IF(AND(A2>30,A2<70),B1+0.75,B1)


Is that the sort of thing you are looking for?

Colin

Yeah, this was what I was trying to look for ;)

But I want it to be at bit more elaborate. Say that I have reached another depth above the 70, lets say 150, where I want the inclination to change again to another set value.

Do you know how to do this aswell?

Thanks!

In that case I would use a lookup table containing the depth ranges and the inclination increase factors for those depths, and I would use the Match worksheet function to lookup the required inclination increase. Note that if the match type argument is -1 then the lookup table must be in descending order.

HTH

Ok. I'll do that. Thanks.