Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
roundup with index,match,subtract,divide and add formula
Stuck again!
Many thanks to 'toothless mama' for helping me modify my formula to this: =(INDEX(Sheet2!$A:$A,MATCH(A62,Sheet2!$F:$F,0))-C61)/2+C61 But, now I need to round up to the next whole number. It's the parenthesis I'm having trouble with. Could someone please straighten me out? Here's what I've got it to: =ROUNDUP(INDEX(Sheet2!$A:$A,MATCH(A62,Sheet2!$F:$F ,0))-C61)/2+C61,0) The parenthesis after '-C62' is messing with me. But if I remove it, the result is wrong. The indexed result is 419; and the value in cell C61 is 128, so the final result should be: (419-128) / 2 + 128 = 273.5 rounded up to 274 (if my math is correct). In any case, I need the formula to round up when original formula results in a fraction. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index and match, then subtract, divide and add for my final answer | 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 | |||
how do I subtract years and then divide | Charts and Charting in Excel |