MrExcel Publishing
Your One Stop for Excel Tips & Solutions

rounddown or ???


Posted by jim on January 28, 2002 11:22 AM

Hi group,

cell entry in Q6 is "4", cell AJ6 = Q6 "4"
how can i show the "4" in AJ6 as "3 1/2" not "4"
Any help or advice is appreciated

Jim


Posted by XL Mon on January 28, 2002 11:30 AM

Please clarify...
are you saying the rule is to round everything down to the closest 1/2?

Posted by jim on January 28, 2002 11:34 AM

I'm sorry, yes rounddown a 1/2" (nt)

Posted by Tom Urtis on January 28, 2002 11:48 AM

Re: I'm sorry, yes rounddown a 1/2" (nt)

Just a suggestion, if your data is in A1, try
=FLOOR(A1,0.5)
Although in your example, the number 4 rounded down to the closes 1/2 increment would return a 4. If your number in A1 was 3.99999, then this formula would round it to 3.5. Is that what you want?

Tom Urtis

Posted by XL Mon on January 28, 2002 11:49 AM

Re: I'm sorry, yes rounddown a 1/2" (nt)


how about AJ6=ROUNDUP(B8-0.4999,0)-0.5
this rounds numbers down to the next 1/2

Posted by jim on January 28, 2002 12:38 PM

Thanks,jim