S
Stuart Johnson
Is there a way to control how amounts are rounded?
In the example below, C2 is calculated as 10% of B2 using the function
=SUM(SUM(B2*0.1)) , C2 is then deducted from C1 to give C3.
A B C
1. Balance 1,134.71
2. 10% 2,477.35 247.74
3. Total 886.98
However, C1 minus C2 =C3 looks 1p adrift due the rounding up. Have I
got the formula wrong, or is there a way to prevent the rounding?
In the example below, C2 is calculated as 10% of B2 using the function
=SUM(SUM(B2*0.1)) , C2 is then deducted from C1 to give C3.
A B C
1. Balance 1,134.71
2. 10% 2,477.35 247.74
3. Total 886.98
However, C1 minus C2 =C3 looks 1p adrift due the rounding up. Have I
got the formula wrong, or is there a way to prevent the rounding?