LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
index and match, then subtract, divide and add for my final answer ladygr Excel Worksheet Functions 3 April 16th 09 11:04 PM
subtract year and divide crystal Excel Worksheet Functions 7 October 26th 05 12:52 AM
how do i subtract and divide crystal Excel Worksheet Functions 1 October 24th 05 10:01 PM
subtract and divide crystal Excel Worksheet Functions 1 October 24th 05 08:22 PM
how do I subtract years and then divide crystal Charts and Charting in Excel 1 October 22nd 05 07:28 PM


All times are GMT +1. The time now is 09:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"