Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Go to Options and check the Precision as Displayed function, is what
you're asking I think. For reference, 4.0 less 1.6 does indeed equal to 2.4 On Nov 5, 4:31 pm, boya716 wrote: I have two cells that I am trying to subtract. Say A1 is 4.0 and B1 is 1.55, both are formatting with ROUND, so A1 rounds to 4.0 and B1 rounds to 1.6. When subtracting these in cell C1, with ROUND function, it reads 2.4. It is subtracting 1.55 from 4.0 instead of 1.6 from 4.0. How do I get it to subtract the final rounded number? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
numbers being rounded | New Users to Excel | |||
how do i add rounded numbers? | Excel Discussion (Misc queries) | |||
ROUNDED NUMBERS IN FORMULA'S | Excel Discussion (Misc queries) | |||
Rounded numbers do not add properly. | Excel Worksheet Functions | |||
incorrect totals using rounded numbers | Excel Discussion (Misc queries) |