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.

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.

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.

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.