| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you round up a cell?
If a cell is 1.678 and I want the cell to round up the nearest tenth which
would be 1.7 how do I do this? I want to disgard the remaining digits after the round up. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you round up a cell?
If you always want to round UP then try
=ROUNDUP(A1,1) where your number is in A1. If you mean the nearest 0.1 i.e. 1.618 to become 1.6 then =ROUND(A1,1) "Chris" wrote: If a cell is 1.678 and I want the cell to round up the nearest tenth which would be 1.7 how do I do this? I want to disgard the remaining digits after the round up. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you round up a cell?
=ROUNDUP(1.68,1)
Dave -- Brevity is the soul of wit. "Chris" wrote: If a cell is 1.678 and I want the cell to round up the nearest tenth which would be 1.7 how do I do this? I want to disgard the remaining digits after the round up. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Excell- a value in a cell, round it up by fives in another cell | New Users to Excel | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Round amount to nearest $10 after other formula calc. in same cell | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
