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