| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number rounding
can i set rounding conditionally? up from .5, down if below?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
number rounding
Use the ROUND() function:
=ROUND(A1,0) will yield 1 if A1 contains 1.1 will yield 2 if A1 contains 1.9 -- Gary's Student "tamiluchi" wrote: can i set rounding conditionally? up from .5, down if below? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
number rounding
I'm doing this for a whole column. Each cell in this column contains an
average for the sum of 2 rows. I want to round the average up if .5 or greater, down if less than .5. I can't make it work. I have ROUND(.5,1), but it rounds all the decimals up, even those less than .5 "Gary''s Student" wrote: Use the ROUND() function: =ROUND(A1,0) will yield 1 if A1 contains 1.1 will yield 2 if A1 contains 1.9 -- Gary's Student "tamiluchi" wrote: can i set rounding conditionally? up from .5, down if below? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
number rounding
Use
=ROUND(A2,0) assuming A2 has the average formula. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "tamiluchi" wrote in message ... I'm doing this for a whole column. Each cell in this column contains an average for the sum of 2 rows. I want to round the average up if .5 or greater, down if less than .5. I can't make it work. I have ROUND(.5,1), but it rounds all the decimals up, even those less than .5 "Gary''s Student" wrote: Use the ROUND() function: =ROUND(A1,0) will yield 1 if A1 contains 1.1 will yield 2 if A1 contains 1.9 -- Gary's Student "tamiluchi" wrote: can i set rounding conditionally? up from .5, down if below? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
number rounding
that seems to work. thank you so very much!!
"Bob Phillips" wrote: Use =ROUND(A2,0) assuming A2 has the average formula. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "tamiluchi" wrote in message ... I'm doing this for a whole column. Each cell in this column contains an average for the sum of 2 rows. I want to round the average up if .5 or greater, down if less than .5. I can't make it work. I have ROUND(.5,1), but it rounds all the decimals up, even those less than .5 "Gary''s Student" wrote: Use the ROUND() function: =ROUND(A1,0) will yield 1 if A1 contains 1.1 will yield 2 if A1 contains 1.9 -- Gary's Student "tamiluchi" wrote: can i set rounding conditionally? up from .5, down if below? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
number rounding
Oh, darn! That works wonderfully except that it rounds up greater than .5 ...
I need it to round up at .5 "tamiluchi" wrote: that seems to work. thank you so very much!! "Bob Phillips" wrote: Use =ROUND(A2,0) assuming A2 has the average formula. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "tamiluchi" wrote in message ... I'm doing this for a whole column. Each cell in this column contains an average for the sum of 2 rows. I want to round the average up if .5 or greater, down if less than .5. I can't make it work. I have ROUND(.5,1), but it rounds all the decimals up, even those less than .5 "Gary''s Student" wrote: Use the ROUND() function: =ROUND(A1,0) will yield 1 if A1 contains 1.1 will yield 2 if A1 contains 1.9 -- Gary's Student "tamiluchi" wrote: can i set rounding conditionally? up from .5, down if below? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
number rounding
No it rounds .5 up. Your value is probably less than .5 but formatted to 1
decimal place so it looks like .5 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "tamiluchi" wrote in message ... Oh, darn! That works wonderfully except that it rounds up greater than .5 .... I need it to round up at .5 "tamiluchi" wrote: that seems to work. thank you so very much!! "Bob Phillips" wrote: Use =ROUND(A2,0) assuming A2 has the average formula. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "tamiluchi" wrote in message ... I'm doing this for a whole column. Each cell in this column contains an average for the sum of 2 rows. I want to round the average up if .5 or greater, down if less than .5. I can't make it work. I have ROUND(.5,1), but it rounds all the decimals up, even those less than .5 "Gary''s Student" wrote: Use the ROUND() function: =ROUND(A1,0) will yield 1 if A1 contains 1.1 will yield 2 if A1 contains 1.9 -- Gary's Student "tamiluchi" wrote: can i set rounding conditionally? up from .5, down if below? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
number rounding
You are so right! Thank you very much... again!
"Bob Phillips" wrote: No it rounds .5 up. Your value is probably less than .5 but formatted to 1 decimal place so it looks like .5 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "tamiluchi" wrote in message ... Oh, darn! That works wonderfully except that it rounds up greater than .5 .... I need it to round up at .5 "tamiluchi" wrote: that seems to work. thank you so very much!! "Bob Phillips" wrote: Use =ROUND(A2,0) assuming A2 has the average formula. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "tamiluchi" wrote in message ... I'm doing this for a whole column. Each cell in this column contains an average for the sum of 2 rows. I want to round the average up if .5 or greater, down if less than .5. I can't make it work. I have ROUND(.5,1), but it rounds all the decimals up, even those less than .5 "Gary''s Student" wrote: Use the ROUND() function: =ROUND(A1,0) will yield 1 if A1 contains 1.1 will yield 2 if A1 contains 1.9 -- Gary's Student "tamiluchi" wrote: can i set rounding conditionally? up from .5, down if below? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
number rounding
On Thu, 20 Apr 2006 08:20:02 -0700, tamiluchi
wrote: can i set rounding conditionally? up from .5, down if below? =ROUND(A1,0) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
| Unwanted rounding of large number | Excel Worksheet Functions | |||
| How to cancel number rounding? | Excel Worksheet Functions | |||
| rounding to a specific number | Excel Worksheet Functions | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
