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

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

--
Message posted from http://www.ExcelForum.com

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

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

"spolk " wrote in message
...
Hi I have the following problem:

Lets assume that i have columns A(Depth) B(pH) C(Org.C%) and
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 value
in column D should be calculated by formula 5,6507*pH+0,743*org.C
+38,082

And everytime then cell value in column A = 20 the corresponding cell
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 succesfull
solutions?


---
Message posted from http://www.ExcelForum.com/