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
