Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round up function
If i have a set of number in a column is is pobbible to somehow use the
rondup function on that column with out having to put the answers into another column? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round up function
Select the cells you would like to modify and run this one-line macro:
Sub shifty() For Each r In Selection r.Value = Application.WorksheetFunction.RoundUp(r.Value, 0) Next End Sub -- Gary''s Student - gsnu200762 "shifty" wrote: If i have a set of number in a column is is pobbible to somehow use the rondup function on that column with out having to put the answers into another column? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round up function
How are the numbers derived?
If they are simply values then a macro will do it but if they are formula derived numbers then this approach could cause formulas to be lost. Mike "shifty" wrote: If i have a set of number in a column is is pobbible to somehow use the rondup function on that column with out having to put the answers into another column? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round up function
=SUMPRODUCT(ROUNDUP(A1:A5,0))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "shifty" wrote in message ... If i have a set of number in a column is is pobbible to somehow use the rondup function on that column with out having to put the answers into another column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round Len Function Help | Excel Worksheet Functions | |||
how do i set up round function | Excel Worksheet Functions | |||
The ROUND function | Excel Worksheet Functions | |||
help with round function | Excel Worksheet Functions | |||
Round Function | Excel Discussion (Misc queries) |