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
|