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 |
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) |