Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index and match, then subtract, divide and add for my final answer
HELLLLP! I'm stuck and you all have been such a great help in the past. I'm
trying to modify my original formula from sheet1 (formula is from cell C62) of: =INDEX('sheet2'!$A:$A,MATCH(A62,'sheet2'!$F:$F,0)) . From the value returned (which is 419), I now must subract 129 (the value from cell C61, also sheet 1). Then divide that number by 2, then add back in the value in C61 (129) to get my final sum. I'm not sure how to incorporate "SUM" with "INDEX,MATCH", or even which function to really use. Any and all help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtract/divide answer/add in one cell | Excel Worksheet Functions | |||
subtract year and divide | Excel Worksheet Functions | |||
how do i subtract and divide | Excel Worksheet Functions | |||
subtract and divide | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |