Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]() "Bill Kuunders" wrote in message ... Ash Looks like you need to round each result before you sum them. Use in b2 =round(A2/12,2) and in c2 =round(B2*0.175,2) before you add them together in d2 Regards Bill K Thanks to both who replied. The Round solution seems to be working fine now. Ash |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding up for down based on cell value | Excel Worksheet Functions | |||
Rounding Issues | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
specific rounding of formulas which may need to include an IF stat | Excel Worksheet Functions |