Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do your round down an entire column?
I am trying to round down an entire column of currency with different
amounts. I can do it with one cell at a time but I need to do the entire column. For example I want to take $15.75 to $15.00 and $14.34 to $14.00 and so on all the way down the column. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do your round down an entire column?
Create a column next to your money column
=ROUNDDOWN(A1,0) A1 would be the 1st cell with your currency, then just copy the formula down "skibum22" wrote: I am trying to round down an entire column of currency with different amounts. I can do it with one cell at a time but I need to do the entire column. For example I want to take $15.75 to $15.00 and $14.34 to $14.00 and so on all the way down the column. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do your round down an entire column?
Hello, tim!
You wrote on Wed, 1 Nov 2006 13:11:02 -0800: tm =ROUNDDOWN(A1,0) tm A1 would be the 1st cell with your currency, then just copy tm the formula down tm "skibum22" wrote: ?? I am trying to round down an entire column of currency ?? with different amounts. I can do it with one cell at a ?? time but I need to do the entire column. For example I ?? want to take $15.75 to $15.00 and $14.34 to $14.00 and so ?? on all the way down the column. What's wrong with INT(A1)? James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
Making a spreadsheet for orders | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
a fomula for an entire column | Excel Discussion (Misc queries) |