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.