Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round X.50 and less down, X.51 and greater up
Is there a ROUND function that I can use that would round numbers ending in the following down? .08 .17 .25 .33 .42 .50 Any other fraction greater than or equal to .51 would be rounded UP. TIA -- BigDave ------------------------------------------------------------------------ BigDave's Profile: http://www.excelforum.com/member.php...fo&userid=7741 View this thread: http://www.excelforum.com/showthread...hreadid=498540 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round X.50 and less down, X.51 and greater up
I'm a bit confused - is your list meant to be of decimals?
If so, you can use the ROUND( ) function to do this, by subtracting 0.01 from your number, e.g.: =ROUND(your_number - 0.01,0) I assume you want the numbers rounded to integers. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round X.50 and less down, X.51 and greater up
Try this:
=IF(MOD(A1,1)0.5,ROUNDUP(A1,0),ROUNDDOWN(A1,0)) HTH, Elkar "BigDave" wrote: Is there a ROUND function that I can use that would round numbers ending in the following down? .08 .17 .25 .33 .42 .50 Any other fraction greater than or equal to .51 would be rounded UP. TIA -- BigDave ------------------------------------------------------------------------ BigDave's Profile: http://www.excelforum.com/member.php...fo&userid=7741 View this thread: http://www.excelforum.com/showthread...hreadid=498540 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|