| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ROUNDDOWN but calculate actual numbers
Hi, I'd like to use the rounddown function on range of cells in a particular column. Not for any other reason but for viewing. I don't need to see 917,248, but rather just 917,200. However, when summing the range, I need the sum to calculate the actuals, not the rounddown numbers. Is this possible? Thanks in advance. EP -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=542027 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Calculate In-Between Numbers | Excel Worksheet Functions | |||
| Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
| How do I automatically calculate YTD numbers by changing a date? | Excel Worksheet Functions | |||
| How do I calculate interest on actual date? | Excel Worksheet Functions | |||
Threaded Mode
