Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
How do I ROUNDUP a Column of cells on a worksheet template? | Excel Worksheet Functions |