I tell ya, I'm starting to work on this using 3 columns for the 3 possible values and 3 columns for the difference, and this is pretty tough!!! Just trying real hard not to use a cursor
You mean if there's a "tie"? Like does a value of 625 evaluate as a 600 or a 650? I would want the lower figure Thanks Albert! Karen -----Original Message----- From: Bruce Chitiea <[email protected]> To: [email protected] <[email protected]> Sent: Mon, Jan 4, 2021 3:17 pm Subject: Re: [RBASE-L] - Rounding up/down #yiv2052924170 #yiv2052924170 #yiv2052924170 #yiv2052924170 --blockquote.yiv2052924170cite {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;}#yiv2052924170 blockquote.yiv2052924170cite2 {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;margin-top:3px;padding-top:0px;}#yiv2052924170 a img {border:0px;}#yiv2052924170 #yiv2052924170 #yiv2052924170 #yiv2052924170 , #yiv2052924170 #yiv2052924170 #yiv2052924170 #yiv2052924170 , #yiv2052924170 #yiv2052924170 #yiv2052924170 #yiv2052924170 , #yiv2052924170 #yiv2052924170 #yiv2052924170 #yiv2052924170 {list-style-position:inside;}#yiv2052924170 body {font-family:Segoe UI;font-size:12pt;}#yiv2052924170 .yiv2052924170quote {margin-left:1em;margin-right:1em;border-left:5px #ebebeb solid;padding-left:0.3em;}#yiv2052924170 Ok, I'll bite. do you break at (24|25), (74|75)? A. Einstein, Genius ------ Original Message ------From: "'Karen Tellef' via RBASE-L" <[email protected]>To: "[email protected]" <[email protected]>Sent: 1/4/2021 11:33:14 AMSubject: [RBASE-L] - Rounding up/down Okay, which of you geniuses out there have a formula to do this for me?? I need to round an integer to the nearest 50 (up or down) IOW: 520 would be 500570 would be 550580 would be 600 Someone have a nifty formula to do that, or do I have to do 3 calculations: how far is each number from 500, how far from 550, how far from 600, and then take whichever is smaller? Karen -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1654091038.1383109.1609788794870%40mail.yahoo.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/emaebfee16-c8e7-4722-98c5-e2bfa45d540b%40pathfinder. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/920737648.5411321.1609795613297%40mail.yahoo.com.
