| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, how do I look for the last number either 0 or 5
On our pricing sheet, we want to round up if the last number of a two decimal
place 5 or more and round down if less than 5 per cell. I know a if statement should do it, but have not been able to complete one. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel, how do I look for the last number either 0 or 5
I think you should be able to do this with a simple ROUND() function...
=ROUND(A1,1) For example, This will turn 45.85 into 45.90 and 45.84 into 45.80. Is this what you wanted? -- Regards, Dave "dd" wrote: On our pricing sheet, we want to round up if the last number of a two decimal place 5 or more and round down if less than 5 per cell. I know a if statement should do it, but have not been able to complete one. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting number value to text value in excel | Excel Worksheet Functions | |||
| Excel - turn a page number in a header from horizontal to vertical | Charts and Charting in Excel | |||
| Excel random number | Excel Discussion (Misc queries) | |||
| Excel 2003 random number generator | Excel Discussion (Misc queries) | |||
| how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
