| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rounding Up Kinda
I am trying to get the following number to round up 541387.4945
"=ROUNDUP(A3,3)or=ROUNDUP(A3,4), but can I combine them? The number should come out to 541387.50 because the 4th digit would round to the 3rd bringing it to five and round the 49 to 50 Thankyou for any help |
|
#2
|
|||
|
|||
|
You're close... =ROUNDUP(A3,2)
-- Regards, Dave "Steve" wrote: I am trying to get the following number to round up 541387.4945 "=ROUNDUP(A3,3)or=ROUNDUP(A3,4), but can I combine them? The number should come out to 541387.50 because the 4th digit would round to the 3rd bringing it to five and round the 49 to 50 Thankyou for any help |
|
#3
|
|||
|
|||
|
Tried that yes it changes it to .50 but it also does it when given a number
like this one, and it should not 541387.4944, this number should stay .49 but get pushed to .50 Steve "David Billigmeier" wrote: You're close... =ROUNDUP(A3,2) -- Regards, Dave "Steve" wrote: I am trying to get the following number to round up 541387.4945 "=ROUNDUP(A3,3)or=ROUNDUP(A3,4), but can I combine them? The number should come out to 541387.50 because the 4th digit would round to the 3rd bringing it to five and round the 49 to 50 Thankyou for any help |
|
#4
|
|||
|
|||
|
Try:
=ROUND(ROUND(A3,3),2) If that doesn't work post like 5 examples showing exactly what you want to do. -- Regards, Dave "Steve" wrote: Tried that yes it changes it to .50 but it also does it when given a number like this one, and it should not 541387.4944, this number should stay .49 but get pushed to .50 Steve "David Billigmeier" wrote: You're close... =ROUNDUP(A3,2) -- Regards, Dave "Steve" wrote: I am trying to get the following number to round up 541387.4945 "=ROUNDUP(A3,3)or=ROUNDUP(A3,4), but can I combine them? The number should come out to 541387.50 because the 4th digit would round to the 3rd bringing it to five and round the 49 to 50 Thankyou for any help |
|
#5
|
|||
|
|||
|
541387.4943 This number would at most round to .4944
541387.4944 This number would round to .4945 then .495 the .50 thats my problem Your formula takes 541387.4944 to 541387.4900 Steve "David Billigmeier" wrote: Try: =ROUND(ROUND(A3,3),2) If that doesn't work post like 5 examples showing exactly what you want to do. -- Regards, Dave "Steve" wrote: Tried that yes it changes it to .50 but it also does it when given a number like this one, and it should not 541387.4944, this number should stay .49 but get pushed to .50 Steve "David Billigmeier" wrote: You're close... =ROUNDUP(A3,2) -- Regards, Dave "Steve" wrote: I am trying to get the following number to round up 541387.4945 "=ROUNDUP(A3,3)or=ROUNDUP(A3,4), but can I combine them? The number should come out to 541387.50 because the 4th digit would round to the 3rd bringing it to five and round the 49 to 50 Thankyou for any help |
|
#6
|
|||
|
|||
|
Why would .4944 round to .4945!? Are you trying to match the 4th decimal
place to the closest multiple of 5 or something? You need to explain what you want better and maybe then we can help you. -- Regards, Dave "Steve" wrote: 541387.4943 This number would at most round to .4944 541387.4944 This number would round to .4945 then .495 the .50 thats my problem Your formula takes 541387.4944 to 541387.4900 Steve "David Billigmeier" wrote: Try: =ROUND(ROUND(A3,3),2) If that doesn't work post like 5 examples showing exactly what you want to do. -- Regards, Dave "Steve" wrote: Tried that yes it changes it to .50 but it also does it when given a number like this one, and it should not 541387.4944, this number should stay .49 but get pushed to .50 Steve "David Billigmeier" wrote: You're close... =ROUNDUP(A3,2) -- Regards, Dave "Steve" wrote: I am trying to get the following number to round up 541387.4945 "=ROUNDUP(A3,3)or=ROUNDUP(A3,4), but can I combine them? The number should come out to 541387.50 because the 4th digit would round to the 3rd bringing it to five and round the 49 to 50 Thankyou for any help |
|
#7
|
|||
|
|||
|
Sorry my mistake .49444 would go to .50, your formula works can I add the 4th
place to it, but it errors out??? =ROUND(ROUND(A11,4),3),2) Thanks again Dave Steve "David Billigmeier" wrote: Why would .4944 round to .4945!? Are you trying to match the 4th decimal place to the closest multiple of 5 or something? You need to explain what you want better and maybe then we can help you. -- Regards, Dave "Steve" wrote: 541387.4943 This number would at most round to .4944 541387.4944 This number would round to .4945 then .495 the .50 thats my problem Your formula takes 541387.4944 to 541387.4900 Steve "David Billigmeier" wrote: Try: =ROUND(ROUND(A3,3),2) If that doesn't work post like 5 examples showing exactly what you want to do. -- Regards, Dave "Steve" wrote: Tried that yes it changes it to .50 but it also does it when given a number like this one, and it should not 541387.4944, this number should stay .49 but get pushed to .50 Steve "David Billigmeier" wrote: You're close... =ROUNDUP(A3,2) -- Regards, Dave "Steve" wrote: I am trying to get the following number to round up 541387.4945 "=ROUNDUP(A3,3)or=ROUNDUP(A3,4), but can I combine them? The number should come out to 541387.50 because the 4th digit would round to the 3rd bringing it to five and round the 49 to 50 Thankyou for any help |
|
#8
|
|||
|
|||
|
No Problem.
Ya just add another ROUND() to the beginning... so it would be =ROUND(ROUND(ROUND(A11,4),3),2) -- Regards, Dave "Steve" wrote: Sorry my mistake .49444 would go to .50, your formula works can I add the 4th place to it, but it errors out??? =ROUND(ROUND(A11,4),3),2) Thanks again Dave Steve "David Billigmeier" wrote: Why would .4944 round to .4945!? Are you trying to match the 4th decimal place to the closest multiple of 5 or something? You need to explain what you want better and maybe then we can help you. -- Regards, Dave "Steve" wrote: 541387.4943 This number would at most round to .4944 541387.4944 This number would round to .4945 then .495 the .50 thats my problem Your formula takes 541387.4944 to 541387.4900 Steve "David Billigmeier" wrote: Try: =ROUND(ROUND(A3,3),2) If that doesn't work post like 5 examples showing exactly what you want to do. -- Regards, Dave "Steve" wrote: Tried that yes it changes it to .50 but it also does it when given a number like this one, and it should not 541387.4944, this number should stay .49 but get pushed to .50 Steve "David Billigmeier" wrote: You're close... =ROUNDUP(A3,2) -- Regards, Dave "Steve" wrote: I am trying to get the following number to round up 541387.4945 "=ROUNDUP(A3,3)or=ROUNDUP(A3,4), but can I combine them? The number should come out to 541387.50 because the 4th digit would round to the 3rd bringing it to five and round the 49 to 50 Thankyou for any help |
|
#9
|
|||
|
|||
|
Great, is there a way to Globally change fomulas?
Steve "David Billigmeier" wrote: No Problem. Ya just add another ROUND() to the beginning... so it would be =ROUND(ROUND(ROUND(A11,4),3),2) -- Regards, Dave "Steve" wrote: Sorry my mistake .49444 would go to .50, your formula works can I add the 4th place to it, but it errors out??? =ROUND(ROUND(A11,4),3),2) Thanks again Dave Steve "David Billigmeier" wrote: Why would .4944 round to .4945!? Are you trying to match the 4th decimal place to the closest multiple of 5 or something? You need to explain what you want better and maybe then we can help you. -- Regards, Dave "Steve" wrote: 541387.4943 This number would at most round to .4944 541387.4944 This number would round to .4945 then .495 the .50 thats my problem Your formula takes 541387.4944 to 541387.4900 Steve "David Billigmeier" wrote: Try: =ROUND(ROUND(A3,3),2) If that doesn't work post like 5 examples showing exactly what you want to do. -- Regards, Dave "Steve" wrote: Tried that yes it changes it to .50 but it also does it when given a number like this one, and it should not 541387.4944, this number should stay .49 but get pushed to .50 Steve "David Billigmeier" wrote: You're close... =ROUNDUP(A3,2) -- Regards, Dave "Steve" wrote: I am trying to get the following number to round up 541387.4945 "=ROUNDUP(A3,3)or=ROUNDUP(A3,4), but can I combine them? The number should come out to 541387.50 because the 4th digit would round to the 3rd bringing it to five and round the 49 to 50 Thankyou for any help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unwanted rounding of large number | Excel Worksheet Functions | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Percentage rounding error in charts | 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) | |||
Linear Mode
