Calculating values to column D with formula based on values column A

[spolk]

Hi I have the following problem:

Lets assume that i have columns A(Depth) B(pH) C(Org.C%) an
D(Hydrogen)


A B C D

0 6 4,62
20 6 0,52

Everytime then cell value in column A = 0 the corresponding cell valu
in column D should be calculated by formula 5,6507*pH+0,743*org.
+38,082

And everytime then cell value in column A = 20 the corresponding cel
value in column D should be calculated by formula
3,087*pH+0,920*org.C +22,909

Does anyone have ready made code or had related problem and succesful
solutions

 

[Cecilkumara Fernando]

spolk,
I changed , to decimal point.
Try this formula in D2 and fill down
=IF(A2,3.087*B2+0.92*C2+22.909,5.65*B2+0.743*C2+38.082)
HTH
Cecil