Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
STK
 
Posts: n/a
Default Roundup for multiple cells

I have quite a few columns I want to roundup the values. I know how to do
=roundup(3.11111,0), but how do I copy that to a bunch of cells?
--
STK
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Instead of 3.11111, put the cell location, such as B2, which should be the
first cell that needs the formula at the top of the column. Then copy the
formula down using the Fill Handle.
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"STK" wrote in message
...
I have quite a few columns I want to roundup the values. I know how to do
=roundup(3.11111,0), but how do I copy that to a bunch of cells?
--
STK



Reply
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
how do you "select locked cells" w/o "select unlocked cells"? princejohnpaulfin Excel Discussion (Misc queries) 3 July 16th 05 03:53 AM
Deselect Cells while using ctrl Sloth Excel Discussion (Misc queries) 5 July 14th 05 10:58 PM
Counting only active cells Sac73 Excel Discussion (Misc queries) 16 April 4th 05 05:49 AM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 01:57 PM
How do I ROUNDUP a Column of cells on a worksheet template? house mouse Excel Worksheet Functions 2 December 16th 04 07:49 PM


All times are GMT +1. The time now is 05:28 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"