ROUND Values (a serie)

[gustaf111]

Hello, it is possible if you have a series of values round them up/down so the values get a fixed number ? In the case below I have used the ROUND function but the sum became 201, I would like the sum to be 200!

Thanks Gustaf

17,64705882 +
61,76470588 +
67,64705882 +
52,94117647 +
= 200

Use ROUND
18
62
68
53
= 201

 

[SteveO59L]

Have a look at rounddown()

 

[gustaf111]

Buth then the sum vill be under 200 I would like the serie to be 200 ..

 

[niceguy_jay]

use this formula

=MROUND(A9,100)

if your value is in cell A9

 

[gustaf111]

Sorry that I explain so bad!!

17,64705882 +
61,76470588 +
67,64705882 +
52,94117647 +
= 200

Use ROUND
18
62
68
53
= 201

I would like to have function that take all the numbers and round them up/down so the sum will be 200.

 

[niceguy_jay]

suppose your series to sum up begins from cell A1 then paste this formula

=MROUND(A1,0.5)

till the end of the series before the = where the numbers to be summed ends

 

[gustaf111]

Thanks!!!

Do ypu know hoe to change to name field for F5 and B6 ?

MAX($F5;$B6);

 

[niceguy_jay]

what do you mean by name field ?

 

[gustaf111]

I have named the F5 cell to "start" and the B6 cell to "stop" and what to use the name instead on of F5 and B6.


MAX($F5;$B6);