Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two values in two seperate cells:
$1.254 $1.254 I have them both set to show 2 decimals so it reads: $1.25 $1.25 So when I add them together with a third cell set at 2 decimal places it reads: $2.51 - because it is adding $1.254 + $1.254 = $2.508 and it is rounding up. Can I get this to read: $1.50? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel rounding | Excel Discussion (Misc queries) | |||
Rounding in Excel | Excel Discussion (Misc queries) | |||
Rounding in Excel | Excel Discussion (Misc queries) | |||
Rounding in excel | Excel Discussion (Misc queries) | |||
rounding in excel | Excel Discussion (Misc queries) |