Hi
I have a worksheet that calculates targets for 29 people based on thier
percentage share of customers within an area using s sumif formula. My
problem is that by allocating % share of a monthly target excel calculates to
decimal points and i then have to overtype results so they add up
particularly where monthly targets are low. Is there a way that I can get
excel to round highest numbers in a range up to interger and lowest results
are rounded down?
Hope someone can help.

To round to the nearest integer:

=ROUND(your_formula_here,0)

--
Biff
Microsoft Excel MVP


"Lilyput" wrote in message
...
Hi
I have a worksheet that calculates targets for 29 people based on thier
percentage share of customers within an area using s sumif formula. My
problem is that by allocating % share of a monthly target excel calculates
to
decimal points and i then have to overtype results so they add up
particularly where monthly targets are low. Is there a way that I can get
excel to round highest numbers in a range up to interger and lowest
results
are rounded down?
Hope someone can help.

Thanks Biff
I have added = Round(),0 to my formula but what happens is that results
below 0.5 are ignored and adding up the results now rounded up does not
result in monthly target. So when my monthly target is 8 I need the eight
highest results in the range to round up so I have allocated the monthly
target When I have added the round part to my first column result is 4 not 8.
Any thing else I can try?

Lilyput



"T. Valko" wrote:

To round to the nearest integer:

=ROUND(your_formula_here,0)

--
Biff
Microsoft Excel MVP


"Lilyput" wrote in message
...
Hi
I have a worksheet that calculates targets for 29 people based on thier
percentage share of customers within an area using s sumif formula. My
problem is that by allocating % share of a monthly target excel calculates
to
decimal points and i then have to overtype results so they add up
particularly where monthly targets are low. Is there a way that I can get
excel to round highest numbers in a range up to interger and lowest
results
are rounded down?
Hope someone can help.


.

The first thing you can try is to post your formula. Without it we can only
guess. From what you've provided, why don't you round the results *after*
you've added them up, rather than before?

Regards,
Fred

"Lilyput" wrote in message
...
Thanks Biff
I have added = Round(),0 to my formula but what happens is that results
below 0.5 are ignored and adding up the results now rounded up does not
result in monthly target. So when my monthly target is 8 I need the eight
highest results in the range to round up so I have allocated the monthly
target When I have added the round part to my first column result is 4
not 8.
Any thing else I can try?

Lilyput



"T. Valko" wrote:

To round to the nearest integer:

=ROUND(your_formula_here,0)

--
Biff
Microsoft Excel MVP


"Lilyput" wrote in message
...
Hi
I have a worksheet that calculates targets for 29 people based on thier
percentage share of customers within an area using s sumif formula. My
problem is that by allocating % share of a monthly target excel
calculates
to
decimal points and i then have to overtype results so they add up
particularly where monthly targets are low. Is there a way that I can
get
excel to round highest numbers in a range up to interger and lowest
results
are rounded down?
Hope someone can help.


.

The formula I have used is
=ROUND(SUM(IF($A5=Customer share!$A$8:$A$36,'Profile'!D$4*'Customer
share'!$G$8:$G$36)),0)
Col A in profile sheet has names, D$4 has monthly targets and percentage
share is taken from customer share sheet col G. Does this help?
I am not sure how to adjust my formula to round after calculation?

"Fred Smith" wrote:

The first thing you can try is to post your formula. Without it we can only
guess. From what you've provided, why don't you round the results *after*
you've added them up, rather than before?

Regards,
Fred

"Lilyput" wrote in message
...
Thanks Biff
I have added = Round(),0 to my formula but what happens is that results
below 0.5 are ignored and adding up the results now rounded up does not
result in monthly target. So when my monthly target is 8 I need the eight
highest results in the range to round up so I have allocated the monthly
target When I have added the round part to my first column result is 4
not 8.
Any thing else I can try?

Lilyput



"T. Valko" wrote:

To round to the nearest integer:

=ROUND(your_formula_here,0)

--
Biff
Microsoft Excel MVP


"Lilyput" wrote in message
...
Hi
I have a worksheet that calculates targets for 29 people based on thier
percentage share of customers within an area using s sumif formula. My
problem is that by allocating % share of a monthly target excel
calculates
to
decimal points and i then have to overtype results so they add up
particularly where monthly targets are low. Is there a way that I can
get
excel to round highest numbers in a range up to interger and lowest
results
are rounded down?
Hope someone can help.


.


.

Are you sure this is the formula? Without "Customer share" surrounded by
apostrophes, I would have expected Excel to give you an error. Also, it
looks like an array formula, but there are no braces around it. Don't type
the formula into the message -- copy and paste it from the formula bar.

Regards,
Fred

"Lilyput" wrote in message
...
The formula I have used is
=ROUND(SUM(IF($A5=Customer share!$A$8:$A$36,'Profile'!D$4*'Customer
share'!$G$8:$G$36)),0)
Col A in profile sheet has names, D$4 has monthly targets and percentage
share is taken from customer share sheet col G. Does this help?
I am not sure how to adjust my formula to round after calculation?

"Fred Smith" wrote:

The first thing you can try is to post your formula. Without it we can
only
guess. From what you've provided, why don't you round the results *after*
you've added them up, rather than before?

Regards,
Fred

"Lilyput" wrote in message
...
Thanks Biff
I have added = Round(),0 to my formula but what happens is that results
below 0.5 are ignored and adding up the results now rounded up does not
result in monthly target. So when my monthly target is 8 I need the
eight
highest results in the range to round up so I have allocated the
monthly
target When I have added the round part to my first column result is 4
not 8.
Any thing else I can try?

Lilyput



"T. Valko" wrote:

To round to the nearest integer:

=ROUND(your_formula_here,0)

--
Biff
Microsoft Excel MVP


"Lilyput" wrote in message
...
Hi
I have a worksheet that calculates targets for 29 people based on
thier
percentage share of customers within an area using s sumif formula.
My
problem is that by allocating % share of a monthly target excel
calculates
to
decimal points and i then have to overtype results so they add up
particularly where monthly targets are low. Is there a way that I
can
get
excel to round highest numbers in a range up to interger and lowest
results
are rounded down?
Hope someone can help.


.


.