Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers dont round up
my numbers do not round up... lets say i have dfferent cells get values based
on different calculation.. ex: A1 get its value from B1. B1=2.7169. when i format A1 to 2 decimal places it show 2.72. now if i multiply A1 by 3 in another cell, instead of showing 8.16 (2.72*3), it shows 8.15 (2.7169*3). i need the cells to calculate based on whats in it. how to i get it to calculate with 2.72 instead of 2.7169??? thanks in advance. -- help a friend help you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers dont round up
cell A1 should contain:
=ROUND(B1,2) "ernie" wrote: my numbers do not round up... lets say i have dfferent cells get values based on different calculation.. ex: A1 get its value from B1. B1=2.7169. when i format A1 to 2 decimal places it show 2.72. now if i multiply A1 by 3 in another cell, instead of showing 8.16 (2.72*3), it shows 8.15 (2.7169*3). i need the cells to calculate based on whats in it. how to i get it to calculate with 2.72 instead of 2.7169??? thanks in advance. -- help a friend help you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers dont round up
Cell A1 =ROUND(B1,2)
"ernie" wrote: my numbers do not round up... lets say i have dfferent cells get values based on different calculation.. ex: A1 get its value from B1. B1=2.7169. when i format A1 to 2 decimal places it show 2.72. now if i multiply A1 by 3 in another cell, instead of showing 8.16 (2.72*3), it shows 8.15 (2.7169*3). i need the cells to calculate based on whats in it. how to i get it to calculate with 2.72 instead of 2.7169??? thanks in advance. -- help a friend help you |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers dont round up
<Tools<Options
"Calculation" tab Click "Precision as displayed" Be careful, though, as you will lose all precision past what you display and won't be able to get it back. -- Regards, Dave "ernie" wrote: my numbers do not round up... lets say i have dfferent cells get values based on different calculation.. ex: A1 get its value from B1. B1=2.7169. when i format A1 to 2 decimal places it show 2.72. now if i multiply A1 by 3 in another cell, instead of showing 8.16 (2.72*3), it shows 8.15 (2.7169*3). i need the cells to calculate based on whats in it. how to i get it to calculate with 2.72 instead of 2.7169??? thanks in advance. -- help a friend help you |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers dont round up
"ernie" wrote:
A1 get its value from B1. B1=2.7169. when i format A1 to 2 decimal places it show 2.72. now if i multiply A1 by 3 in another cell, instead of showing 8.16 (2.72*3), it shows 8.15 (2.7169*3). i need the cells to calculate based on whats in it. how to i get it to calculate with 2.72 instead of 2.7169??? Two ways .... Perhaps the easiest is to selected Tools Options Calculations "Precision as displayed". But I would not do that myself because of unexpected consequences. Sometimes, you want the hidden extra precision to work for you. The alternative is to use the ROUND(), ROUNDUP() and ROUNDDOWN() functions where you want them. For example, change the formula in A1 to ROUND(B1,2). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
HOW DO I SELECT ROUND NUMBERS ONLY IN EXCEL SPREADSHEET | Excel Worksheet Functions | |||
round numbers to the nearest quarter? | Excel Worksheet Functions | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |