| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I round a number to the nearest 600 in Excel?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a number to the nearest 600 in Excel?
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a number to the nearest 600 in Excel?
Use =MROUND(A1,600)
You need to have the Analysis ToolPac installed to have this function Otherwise =ROUND(A1/600,0)*600 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Barcelona" wrote in message ... I need to round numbers to the nearest multiple of 600. For example if the number is 15,443, I am looking for a formula that would round the number to 15,600. Is there one? Judy Sanchez |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a number to the nearest 600 in Excel?
Alternatively, you could try this:
=IF(CEILING(A1,600)-A1300,FLOOR(A1,600),CEILING(A1,600)) Hope this helps. Pete On Jan 25, 5:23 pm, "Bernard Liengme" wrote: Use =MROUND(A1,600) You need to have the Analysis ToolPac installed to have this function Otherwise =ROUND(A1/600,0)*600 best wishes -- Bernard V Liengmewww.stfx.ca/people/bliengme remove caps from email "Barcelona" wrote in ... I need to round numbers to the nearest multiple of 600. For example if the number is 15,443, I am looking for a formula that would round the number to 15,600. Is there one? Judy Sanchez - Hide quoted text -- Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a number to the nearest 600 in Excel?
Bit of overkill isn't it? <G
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Pete_UK" wrote in message oups.com... Alternatively, you could try this: =IF(CEILING(A1,600)-A1300,FLOOR(A1,600),CEILING(A1,600)) Hope this helps. Pete On Jan 25, 5:23 pm, "Bernard Liengme" wrote: Use =MROUND(A1,600) You need to have the Analysis ToolPac installed to have this function Otherwise =ROUND(A1/600,0)*600 best wishes -- Bernard V Liengmewww.stfx.ca/people/bliengme remove caps from email "Barcelona" wrote in ... I need to round numbers to the nearest multiple of 600. For example if the number is 15,443, I am looking for a formula that would round the number to 15,600. Is there one? Judy Sanchez - Hide quoted text -- Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a number to the nearest 600 in Excel?
Yeah, at first I thought "ceiling", so checked it out to see that I had
the right syntax, then re-read the post and realised the OP wanted to round OFF to the nearest 600, and one thing led to another ... Sometimes you get into a fixed mindset !! <bg Anyway, it's ONE way of doing it !! Pete On Jan 25, 7:10 pm, "Bob Phillips" wrote: Bit of overkill isn't it? <G -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Pete_UK" wrote in ooglegroups.com... Alternatively, you could try this: =IF(CEILING(A1,600)-A1300,FLOOR(A1,600),CEILING(A1,600)) Hope this helps. Pete On Jan 25, 5:23 pm, "Bernard Liengme" wrote: Use =MROUND(A1,600) You need to have the Analysis ToolPac installed to have this function Otherwise =ROUND(A1/600,0)*600 best wishes -- Bernard V Liengmewww.stfx.ca/people/bliengme remove caps from email "Barcelona" wrote in ... I need to round numbers to the nearest multiple of 600. For example if the number is 15,443, I am looking for a formula that would round the number to 15,600. Is there one? Judy Sanchez - Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text - |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a number to the nearest 600 in Excel?
"Pete_UK" wrote in message oups.com... Yeah, at first I thought "ceiling", so checked it out to see that I had the right syntax, then re-read the post and realised the OP wanted to round OFF to the nearest 600, and one thing led to another ... Sometimes you get into a fixed mindset !! <bg Been there <ebg |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a number to the nearest 600 in Excel?
|
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a number to the nearest 600 in Excel?
just literally maybe
=MAX((A1<600)*600,ROUND(A1/600,0)*600) for +/- numbers only -- ***** birds of the same feather flock together.. "Barcelona" wrote: I need to round numbers to the nearest multiple of 600. For example if the number is 15,443, I am looking for a formula that would round the number to 15,600. Is there one? Judy Sanchez |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I round a number to the nearest 600 in Excel?
disregard the previous
i am confused maybe with this another overkill =IF(ABS(A1)<600,SIGN(A1)*600,ROUND(A1/600,0)*600) -- ***** birds of the same feather flock together.. "driller" wrote: just literally maybe =MAX((A1<600)*600,ROUND(A1/600,0)*600) for +/- numbers only -- ***** birds of the same feather flock together.. "Barcelona" wrote: I need to round numbers to the nearest multiple of 600. For example if the number is 15,443, I am looking for a formula that would round the number to 15,600. Is there one? Judy Sanchez |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
| Roundup to the nearest number that is divisible by 3 | Excel Worksheet Functions | |||
| WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
