Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Problem
I give below the calculation chart which I have prepared.
A10 B10 C10 D10 E10 F10 G10 2318 2318 2318 2318 2588 2588 2588 H10 I10 J10 Total 2588 2588 2588 24795 the figures were arrived at by formula =SUM(D3,D4)*30% , where for column A & B, A3 & B3 were 5150 and 2575 resp, and for the remaining columns 5750 and 2875 resp. In actual calculation the figures comes to 2317.5 for column A10 &B10 and 2587.5 for remainlng columns. The figures were rounded up to 2318 & 2588 by using 'increase decimal sign'. Now when I am adding the row A10 to J10 I am getting 24795 instead of 24800 which I want. I think difference of 5 which I am getting is due to rounding up, but how do I a write the formula for the correction, so that in total I get 24800 instead of 24795. Further I would like to know how do I round up a number to nearest 10, i.e. how do I make 4285 to read as 4290 and 4284 to read as 4280. Sorry for the rather lengthy post but could not make it any shorter to my satisfaction. Your help will be highly appreciated. TIA. |
#2
|
|||
|
|||
Hi
the 'increase decimal sign' doesn't really round, it only changes the way the data is displayed. If you want to round a number to the nearest 10 use =ROUND(your_formula,-1) e.g. =ROUND((D3+D4)*30%,-1) Cheers JulieD "J.C.De" wrote in message ... I give below the calculation chart which I have prepared. A10 B10 C10 D10 E10 F10 G10 2318 2318 2318 2318 2588 2588 2588 H10 I10 J10 Total 2588 2588 2588 24795 the figures were arrived at by formula =SUM(D3,D4)*30% , where for column A & B, A3 & B3 were 5150 and 2575 resp, and for the remaining columns 5750 and 2875 resp. In actual calculation the figures comes to 2317.5 for column A10 &B10 and 2587.5 for remainlng columns. The figures were rounded up to 2318 & 2588 by using 'increase decimal sign'. Now when I am adding the row A10 to J10 I am getting 24795 instead of 24800 which I want. I think difference of 5 which I am getting is due to rounding up, but how do I a write the formula for the correction, so that in total I get 24800 instead of 24795. Further I would like to know how do I round up a number to nearest 10, i.e. how do I make 4285 to read as 4290 and 4284 to read as 4280. Sorry for the rather lengthy post but could not make it any shorter to my satisfaction. Your help will be highly appreciated. TIA. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Defined range problem | Excel Discussion (Misc queries) | |||
Baffling formula problem | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) |