| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding
Hello
Can someone Help me.. I'm stuck!! can you tell me the formula for round up...after .49? if the number is 7.6.. I want to round to 8. Any help is greatly appreciated... Lime |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
and what if less than or equal to 0.49
=IF(MOD(A1,1)0.49,ROUND(A1,0),A1) If this post helps click Yes --------------- Jacob Skaria "Lime" wrote: Hello Can someone Help me.. I'm stuck!! can you tell me the formula for round up...after .49? if the number is 7.6.. I want to round to 8. Any help is greatly appreciated... Lime |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
Thank you that did it!!!
"Jacob Skaria" wrote: and what if less than or equal to 0.49 =IF(MOD(A1,1)0.49,ROUND(A1,0),A1) If this post helps click Yes --------------- Jacob Skaria "Lime" wrote: Hello Can someone Help me.. I'm stuck!! can you tell me the formula for round up...after .49? if the number is 7.6.. I want to round to 8. Any help is greatly appreciated... Lime |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
If you really want to round up after .49, and down for values below .49 ,
then =INT(A1)+(MOD(A1,1)0.49) This would round up for .495 You may need to think about how you want to treat negative numbers. If you just want to round up for .5 and upwards, and down for values below ..5, then =ROUND(A1,0) -- David Biddulph "Lime" wrote in message ... Hello Can someone Help me.. I'm stuck!! can you tell me the formula for round up...after .49? if the number is 7.6.. I want to round to 8. Any help is greatly appreciated... Lime |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
=MAX(A1,ROUND(A1,))
"Lime" wrote: Hello Can someone Help me.. I'm stuck!! can you tell me the formula for round up...after .49? if the number is 7.6.. I want to round to 8. Any help is greatly appreciated... Lime |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| Rounding Up to the 50 | Excel Discussion (Misc queries) | |||
| Rounding | Excel Discussion (Misc queries) | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Rounding | Excel Discussion (Misc queries) | |||
Linear Mode
