| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
| Formula: values in one column based on corresponding data | New Users to Excel | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
![spolk[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
