Rounding Up Decimals

How do I get 14.102 to say 14.11? Thanks!!

=roundup(A1,2)

where A1 contains the original.

=CEILING(14.102,0.01)


--

Regards,

Peo Sjoblom

"Lilbit" <[email protected]> wrote in message
news:[email protected]...
> How do I get 14.102 to say 14.11? Thanks!!
>

Thanks to you both; however, I think I neglected to provide enough
information. I have a formula (=sum(G40/G44)) where the answer is 4.102.
I need the answer to come to 4.11. Thanks for your help!!

Thanks to you both; however, I think I neglected to provide enough
information. I have a formula (=sum(G40/G44)) where the answer is 4.102.
I need the answer to come to 4.11. Thanks for your help!!

=CEILING(G40/G44,0.01)

--

Regards,

Peo Sjoblom

"Lilbit" <[email protected]> wrote in message
news:[email protected]...
> Thanks to you both; however, I think I neglected to provide enough
> information. I have a formula (=sum(G40/G44)) where the answer is 4.102.
> I need the answer to come to 4.11. Thanks for your help!!
>

Thanks for the updated formula. However, I don't know what I'm doing
wrong, but I'm coming up with 15.00%, not 14.11%.

With the addition of the percent format, you have to think of your number as having two additional decimal places (14.102%=0.14102) and roundup(value,4) or ceiling(value,0.0001)

Thank you, Thank you, Thank you!!