View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ladygr ladygr is offline
external usenet poster
 
Posts: 16
Default 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.