Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding down
I was wondering if anyone can tell me if this is possible. I need to create
a formula based on the results of date in two separate fileds. Suppose I have a field with 31064.47 and another with 28738. I wand to subtract the 2nd number from the first, then round the result to the nearest increment of 500. For example, 31064.47 subtract 28738 equals 2326.47. I would like to round that result down to the nearest increment of 500 or 2000. Can this be done, and how? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding down
Say you have your 2 numbers in A1 and A2, then where you do the calculation,
enter the following formula: =ROUNDDOWN(A1-A2,-3) "John" wrote: I was wondering if anyone can tell me if this is possible. I need to create a formula based on the results of date in two separate fileds. Suppose I have a field with 31064.47 and another with 28738. I wand to subtract the 2nd number from the first, then round the result to the nearest increment of 500. For example, 31064.47 subtract 28738 equals 2326.47. I would like to round that result down to the nearest increment of 500 or 2000. Can this be done, and how? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding down
=FLOOR(A1-A2,500)
-- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "John" wrote in message ... I was wondering if anyone can tell me if this is possible. I need to create a formula based on the results of date in two separate fileds. Suppose I have a field with 31064.47 and another with 28738. I wand to subtract the 2nd number from the first, then round the result to the nearest increment of 500. For example, 31064.47 subtract 28738 equals 2326.47. I would like to round that result down to the nearest increment of 500 or 2000. Can this be done, and how? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding down
Hello,
If the second number can be greater than the first and if the multiple of 500 has to be <= the difference: 1. =IF(A1-A20,ROUNDDOWN((A1-A2)*2,-3)/2,ROUNDUP((A1-A2)*2/-3)/2) 2. =IF(A1-A20,FLOOR(A1-A2,500),CEILING(A1-A2,-500)) HTH, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding or not rounding | Excel Worksheet Functions | |||
Unwanted rounding of large number | Excel Worksheet Functions | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |