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

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

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

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

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

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

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

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

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