| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically round small calculated values to zero
Excel (Office 2000 or Office XP) often gives a calculated cell value that
technically should be zero as a very small number instead, say with absolute value less than 1e-15. Can I set a format so calculated values below a certain size limit will be given as zero? Writing an IF statement in each case is, of course, not a very practical solution. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically round small calculated values to zero
Some info here on rounding issues:
http://www.cpearson.com/excel/rounding.htm "Keypoker2" wrote: Excel (Office 2000 or Office XP) often gives a calculated cell value that technically should be zero as a very small number instead, say with absolute value less than 1e-15. Can I set a format so calculated values below a certain size limit will be given as zero? Writing an IF statement in each case is, of course, not a very practical solution. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Values | Excel Worksheet Functions | |||
| How do I get a calculated amount to round to the nearest nickel? | Excel Worksheet Functions | |||
| Eliminating 0 values when using the Small formula | Excel Worksheet Functions | |||
| Use criteria for values in range for small function | Excel Worksheet Functions | |||
| In Excel, how do you get it to not automatically round my dollars. | Excel Worksheet Functions | |||
Linear Mode
