Thanks Bill and Robert, they both worked flawlessly... Now I need to ask myself..."Why couldn't I see that!?!?"
-----Original Message----- From: William M Conlon [mailto:[EMAIL PROTECTED] Sent: Monday, February 18, 2008 10:57 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: A Calculation or <@CALC ((floor(<@ARG val>/20))*20)+1> Bill On Feb 18, 2008, at 8:47 AM, Robert Shubert wrote: > Maybe: > > <@CALC ((ceil(<@ARG val>/20))*20)-19> > > From: WebDude [mailto:[EMAIL PROTECTED] > Sent: Monday, February 18, 2008 11:27 AM > To: witango-talk@witango.com > Subject: Witango-Talk: A Calculation > > Sorry, but I am totally daft at this. I am trying to come up with a > calc tag that will do the following. I have tried all sorts of calcs > using ceil and floor, but I just can't seem to get this right. Maybe > some of you who are a bit more adept at this could help me out. > > I have a bunch of numbers. These are not returns from a search or > anything like that, so using <@totalrows> <@maxrows> and <@numrows> > will not help. > > For every block of numbers, I would like a calc that will spit out a > number rounded to the lowest 20 plus 1. Kind of hard to explain, but > the following would be a good example... > > Numbers Result > 1 through 20 1 > 21 through 40 21 > 41 through 60 41 > 61 through 80 61 > > etc. etc. etc > > > So if you put in 14 the result would be 1 If you put in 18 the result > would be 1 If you put in 26 the result would be 21 If you put in 22 > the result would be 21 If you put in 44 the result would be 41 If you > put in 47 the result would be 41 > > etc. etc. etc. > > Is there a calculation that can work something like this out? I have > been going round and round trying to figure this one out. > Maybe some of you math Gods could help. > > > > ______________________________________________________________________ > __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/ > maillist.taf > ______________________________________________________________________ > __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf