From: HunterX on 2 Jun 2010 10:46 Hello, I haven't had any success in trying to do the following: I have a column of hours  all with .50 (such as 8.50, 7.50, 1.50, etc.) I am trying to program a routine to go down the column cell by cell and alternately round the first cell up to the nearest whole number, round the second cell down to the nearest whole number, round the third one up to the nearest whole number, etc. I appreciate any help with this. Thank you !!
From: Roger Govier on 2 Jun 2010 11:15 Hi Try =IF(MOD(ROW(),2)<>0,ROUNDUP(A1,0),ROUNDDOWN(A1,0)) Depending upon whether the first row you are trying to Roundup is Odd (use formula as is) or if even the change <> to = Copy down as required  Regards Roger Govier "HunterX" <HunterX(a)discussions.microsoft.com> wrote in message news:8940C43CFD2647F7ADA42A56A61D3373(a)microsoft.com... > Hello, > > I haven't had any success in trying to do the following: > > I have a column of hours  all with .50 (such as 8.50, 7.50, 1.50, etc.) > > I am trying to program a routine to go down the column cell by cell and > alternately round the first cell up to the nearest whole number, round the > second cell down to the nearest whole number, round the third one up to > the > nearest whole number, etc. > > I appreciate any help with this. Thank you !! > > __________ Information from ESET Smart Security, version of virus > signature database 5166 (20100602) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > __________ Information from ESET Smart Security, version of virus signature database 5166 (20100602) __________ The message was checked by ESET Smart Security. http://www.eset.com
From: Jim Cone on 2 Jun 2010 11:23 Another way (requires the Analysis ToolPak)... =MROUND(A1,2)  Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware "HunterX" <HunterX(a)discussions.microsoft.com> wrote in message Hello, I haven't had any success in trying to do the following: I have a column of hours  all with .50 (such as 8.50, 7.50, 1.50, etc.) I am trying to program a routine to go down the column cell by cell and alternately round the first cell up to the nearest whole number, round the second cell down to the nearest whole number, round the third one up to the nearest whole number, etc. I appreciate any help with this. Thank you !!
From: Tom Hutchins on 2 Jun 2010 11:28 If the first number is in an oddnumbered row (cell A1 in my example), try this formula: =IF(MOD(ROW(),2)=1,CEILING(A1,1),FLOOR(A1,1)) and copy down. If the first number is in an evennumbered row (cell A2 in my example), try this version: =IF(MOD(ROW(),2)=0,CEILING(A2,1),FLOOR(A2,1)) and copy down. CEILING rounds up, FLOOR rounds down. Hope this helps, Hutch "HunterX" wrote: > Hello, > > I haven't had any success in trying to do the following: > > I have a column of hours  all with .50 (such as 8.50, 7.50, 1.50, etc.) > > I am trying to program a routine to go down the column cell by cell and > alternately round the first cell up to the nearest whole number, round the > second cell down to the nearest whole number, round the third one up to the > nearest whole number, etc. > > I appreciate any help with this. Thank you !!
From: T. Valko on 2 Jun 2010 11:34 >round the first cell up to the nearest whole number >round the second cell down to the nearest whole number Assuming the numbers start in cell A2, enter this formula in B2 and copy down as needed: =IF(MOD(ROWS(A$2:A2),2),A2+0.5,A20.5)  Biff Microsoft Excel MVP "HunterX" <HunterX(a)discussions.microsoft.com> wrote in message news:8940C43CFD2647F7ADA42A56A61D3373(a)microsoft.com... > Hello, > > I haven't had any success in trying to do the following: > > I have a column of hours  all with .50 (such as 8.50, 7.50, 1.50, etc.) > > I am trying to program a routine to go down the column cell by cell and > alternately round the first cell up to the nearest whole number, round the > second cell down to the nearest whole number, round the third one up to > the > nearest whole number, etc. > > I appreciate any help with this. Thank you !!

Next

Last
Pages: 1 2 Prev: Counting Occurrence of a Value within Cells Next: difference between two time 