LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Alternate Rounding Up & Down of .50 in a column

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 !!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy reference cell with alternate column aclim Excel Discussion (Misc queries) 4 February 4th 09 11:36 PM
formula alternate column call value Jarek Kujawa[_2_] Excel Worksheet Functions 0 July 15th 08 11:30 AM
formula alternate column call value vlook fomula Excel Worksheet Functions 1 July 15th 08 11:29 AM
Add alternate cells in column and sum Jackanorry Excel Worksheet Functions 4 March 23rd 08 06:28 PM
How can I choose alternate rows in a column? pnair New Users to Excel 2 December 17th 05 05:16 AM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"