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

=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

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