L
Lilbit
How do I get 14.102 to say 14.11? Thanks!!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
Vito
=roundup(A1,2
where A1 contains the original
where A1 contains the original
P
Peo Sjoblom
=CEILING(14.102,0.01)
L
Lilbit
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!!
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!!
L
Lilbit
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!!
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!!
P
Peo Sjoblom
=CEILING(G40/G44,0.01)
L
Lilbit
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%.
wrong, but I'm coming up with 15.00%, not 14.11%.
M
MrShorty
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)
number as having two additional decimal places (14.102%=0.14102) and
roundup(value,4) or ceiling(value,0.0001)
L
Lilbit
Thank you, Thank you, Thank you!!