| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
round result of sumif formula
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUND the result of a formula | Excel Worksheet Functions | |||
| how to round down the result of a formula | Excel Worksheet Functions | |||
| How do I get formula result of 3.56 to round up to 4 automatic? | Excel Worksheet Functions | |||
| How do I get formula result of 3.56 to round up to 4 automatic? | Excel Worksheet Functions | |||
| how do I round up a result of a formula in Excel | Excel Worksheet Functions | |||
Threaded Mode
