| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round formulas
Hello,
I need a formula that will round up or down based on .7 decimal rather than ..5. For example, the number 45.7 would round up to 46. The number 45.6 would round down to 45. Is there a formula to help me do this? I appreciate any help I can get. Thank you. ~Meghan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round formulas
Try this
=IF(MOD(A1,1)=0.7,ROUNDUP(A1,0),ROUNDDOWN(A1,0)) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mstack" wrote in message ... Hello, I need a formula that will round up or down based on .7 decimal rather than .5. For example, the number 45.7 would round up to 46. The number 45.6 would round down to 45. Is there a formula to help me do this? I appreciate any help I can get. Thank you. ~Meghan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round formulas
Alternative
=INT(A1)+(MOD(A1,1)=0.7) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mstack" wrote in message ... Hello, I need a formula that will round up or down based on .7 decimal rather than .5. For example, the number 45.7 would round up to 46. The number 45.6 would round down to 45. Is there a formula to help me do this? I appreciate any help I can get. Thank you. ~Meghan |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round formulas
hi,
try to use: =if(c3-int(c3)=0.6999,(1-(c3-int(c3))+c3),int(c3)) hth regards from Brazil Marcelo "mstack" escreveu: Hello, I need a formula that will round up or down based on .7 decimal rather than .5. For example, the number 45.7 would round up to 46. The number 45.6 would round down to 45. Is there a formula to help me do this? I appreciate any help I can get. Thank you. ~Meghan |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round formulas
Hello Meghan,
=INT(A1+0.3) HTH, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
| How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Hybrid Mode
