roundup with index,match,subtract,divide and add formula

  • Thread starter Thread starter ladygr
  • Start date Start date
L

ladygr

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.
 
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.
 
You're Welcome!

ladygr said:
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.
 
Back
Top