Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() i have variables A,B,C,D,E, which C and D's calculations depends on the values of A and B. E = C/D. Now i have a column of different A values and I need to evaluate for each A, what is the corresponding E value. sample table: Values A E A = 10 15 corresponding value to A = 15 B = 20 20 corresponding value to A = 20 C = function of A & B. 25 " D = function of A & B. 30 " E= C/D 35 " 40 " is there a way I can edit the formula for E values in the 3rd column to drag down for each corresponding value of A? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
How sum values in column B using values in column A as the conditi | Excel Worksheet Functions |