| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding Up Decimals
How do I get 14.102 to say 14.11? Thanks!!
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Up Decimals
=roundup(A1,2) where A1 contains the original. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=497922 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Up Decimals
=CEILING(14.102,0.01)
-- Regards, Peo Sjoblom "Lilbit" wrote in message lkaboutsoftware.com... How do I get 14.102 to say 14.11? Thanks!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Up Decimals
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!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Up Decimals
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!! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Up Decimals
=CEILING(G40/G44,0.01)
-- Regards, Peo Sjoblom "Lilbit" wrote in message lkaboutsoftware.com... 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!! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Up Decimals
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%. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Up Decimals
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) -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=497922 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Up Decimals
Thank you, Thank you, Thank you!!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format monetary amount to 9 digits with No decimals without rounding | Excel Worksheet Functions | |||
| Rounding Decimals | Excel Discussion (Misc queries) | |||
| Rounding results to nearest quarter (in decimals) | Excel Discussion (Misc queries) | |||
| rounding numbers, with-out decimals. IE:4507 to 4510 | Excel Worksheet Functions | |||
| Rounding Decimals | Excel Worksheet Functions | |||
Linear Mode
