If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to make value whole (remove decimal point)
I have a column with values that have up to 4 places to the right of the
decimal point (32.2514) and I simply want the whole value rounded up, and I don't want it just to show the rounded up value, I actually want the cell value to be 32 if the number is 32.2145. please help..... thanks |
#2
|
|||
|
|||
how to make value whole (remove decimal point)
value to be 32 if the number is 32.2145
is actually rounding DOWN not up. To do that use: INT(A1) or TRUNC(A1) (They act differently with negative numeber - check in Help) If you want to round to the nearest whole number use: =ROUND(A1,0) If you do want to round up ALL the time then use: ROUNDUP(A1,0) or CEILING(A1,1) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Roger" wrote in message ... I have a column with values that have up to 4 places to the right of the decimal point (32.2514) and I simply want the whole value rounded up, and I don't want it just to show the rounded up value, I actually want the cell value to be 32 if the number is 32.2145. please help..... thanks |
Thread Tools | |
Display Modes | |
|
|