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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
roundup with index,match,subtract,divide and add formula
=ROUNDUP((INDEX(Sheet2!$A:$A,MATCH(A62,Sheet2!$F:$ F,0))-C61)/2+C61,0)
"ladygr" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
roundup with index,match,subtract,divide and add formula
You're not only good, but fast too! Saved again, thank you. It was the double
parenthesis in front of INDEX. Who knew. Excel did make one correction to your formula. It put another paranthesis at the end so it reads: =ROUNDUP((INDEX(Sheet2!$A:$A,MATCH(A62,Sheet2!$F:$ F,0))-C61)/2+C61,0)) and it works perfectly. Again, thank you. "Teethless mama" wrote: =ROUNDUP((INDEX(Sheet2!$A:$A,MATCH(A62,Sheet2!$F:$ F,0))-C61)/2+C61,0) "ladygr" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
roundup with index,match,subtract,divide and add formula
You're Welcome!
"ladygr" wrote: You're not only good, but fast too! Saved again, thank you. It was the double parenthesis in front of INDEX. Who knew. Excel did make one correction to your formula. It put another paranthesis at the end so it reads: =ROUNDUP((INDEX(Sheet2!$A:$A,MATCH(A62,Sheet2!$F:$ F,0))-C61)/2+C61,0)) and it works perfectly. Again, thank you. "Teethless mama" wrote: =ROUNDUP((INDEX(Sheet2!$A:$A,MATCH(A62,Sheet2!$F:$ F,0))-C61)/2+C61,0) "ladygr" wrote: 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. |
Reply |
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 |