| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to round a cell value in formula
If a cell contains a value such as 4.13, but in a formula I want to use the
rounded value which would be 4, how do I do that? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to round a cell value in formula
On Tue, 24 Jan 2006 18:57:04 -0800, "Ducky"
wrote: If a cell contains a value such as 4.13, but in a formula I want to use the rounded value which would be 4, how do I do that? ' =ROUND(4.13,0) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round formula | Excel Worksheet Functions | |||
| How do i round up an answer in a cell that has a formula attached? | Excel Worksheet Functions | |||
| Round amount to nearest $10 after other formula calc. in same cell | Excel Worksheet Functions | |||
| How do I NOT round off in a formula | Excel Worksheet Functions | |||
| How to round up the result in a cell containing formula | Excel Worksheet Functions | |||
Linear Mode
