Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rounding Question
Heres the short end of what Im trying to do. I am trying to subtract two dates and return the number of months between the two dates. I can get this part. The catch here is that I want the number of months to come back as either whole months or half months. So 1/1/05-2/1/05 = 1 month and 1/1/05-2/15/05 = 1.5 months. My problem is that when I run the calc I get numbers like 1.64 and using a round will give me 1.6 whereas I would want this number to come back as 1.5. Any ideas? -- Rweasel6 ------------------------------------------------------------------------ Rweasel6's Profile: http://www.excelforum.com/member.php...o&userid=23251 View this thread: http://www.excelforum.com/showthread...hreadid=379078 |
#2
|
|||
|
|||
=floor(1.64,0.5)
will reduce 1.64 to 1.5 so you could enclose your formula as =floor(your formula,0.5) also take a look at function CEILING to round up your values to nearest 0.5 "Rweasel6" wrote in message ... Heres the short end of what Im trying to do. I am trying to subtract two dates and return the number of months between the two dates. I can get this part. The catch here is that I want the number of months to come back as either whole months or half months. So 1/1/05-2/1/05 = 1 month and 1/1/05-2/15/05 = 1.5 months. My problem is that when I run the calc I get numbers like 1.64 and using a round will give me 1.6 whereas I would want this number to come back as 1.5. Any ideas? -- Rweasel6 ------------------------------------------------------------------------ Rweasel6's Profile: http://www.excelforum.com/member.php...o&userid=23251 View this thread: http://www.excelforum.com/showthread...hreadid=379078 |
#3
|
|||
|
|||
works great thanks!!! -- Rweasel6 ------------------------------------------------------------------------ Rweasel6's Profile: http://www.excelforum.com/member.php...o&userid=23251 View this thread: http://www.excelforum.com/showthread...hreadid=379078 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rounding time question | Excel Worksheet Functions | |||
Rounding Question | Excel Worksheet Functions | |||
rounding question | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |