Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need a formula that will only round if the decimal of the result is greater
than something ##.5, otherwise I don't want the formula to round. Below is an example of what I've developed so far, but I need to know how to enter in a value into the formula to indicate a number with a decimal greater than .5 =IF(AVERAGE(B1:D1)=##.5,ROUND(AVERAGE(B1:D1),0),A VERAGE(B1:D1)) Ultimately what the formula will needs to do is average 3 numbers, rounding up only if the resulting decimal value is greater than .5, otherwise, the formula should not round at all. Example: When I enter the following numbers the results will round due to the decimal being greater than or equal to .5 (90 + 76 + 70)/3 = 78.6667 Result to display will be 79 However if I enter the following numbers the results will not round due to the decimal being less than .5 (85 + 80 + 70)/3 = 78.3333 Result to display will be 78.3333 Thank you to anyone that can help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unwanted rounding of large number | Excel Worksheet Functions | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) | |||
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) |