Roundup

[Bob]

Simple question, just want to make sure I'm on the right track.
=Roundup(C34/A34,2)
My results came out to .0368, I want the results to come out .04 and
calcuatate by .04 rather than .0368. Is this the correct way to do so?
Thanks in Advance!!!

 

[Claus Busch]

Hi Bob,

Am Fri, 22 Jul 2011 12:42:25 -0700 (PDT) schrieb Bob:

Simple question, just want to make sure I'm on the right track.
=Roundup(C34/A34,2)
My results came out to .0368, I want the results to come out .04 and
calcuatate by .04 rather than .0368. Is this the correct way to do so?

with roundup will .0322 also shown as .04
If you want .0322 to come out .03 you should try:
=ROUND(C34/A34,2)


Regards
Claus Busch

 

[isabelle]

hi,

=CEILING(C34/A34,0.01)

 

[Bob]

hi,

=CEILING(C34/A34,0.01)

--
isabelle

Le 2011-07-22 15:42, Bob a écrit :




- Show quoted text -

Thanks so much, Thats what I needed