Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! Trying to create a nested formula
I am having a problem nesting this calculation, in addition the final sum
should be rounded to 34k....do not know where I am going wrong Example: Payment Gross Up Sum Rounded 32,549.00 976.47 33,525.47 30,000.00 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! Trying to create a nested formula
Hi,
You didn't give any rules for the rounding - up or down or nearest so I'll guess nearest 1000 so with the sum of your numbers in C2 try this =ROUND(C2/1000,0)*1000 Mike "Alabama" wrote: I am having a problem nesting this calculation, in addition the final sum should be rounded to 34k....do not know where I am going wrong Example: Payment Gross Up Sum Rounded 32,549.00 976.47 33,525.47 30,000.00 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! Trying to create a nested formula
Hi,
You didn't tell us what formula you are using? If you want to round a sum to the nearest 1000, you can do this with formatting (for display only or using a round to actually change the number). Formatting to the nearest 1K =SUM(A1:A100) choose Format, Cells, Number tab, Custom and enter either #0,K or 0,K To round to the nearest 1K =ROUND(A1,-3) Which you could format using the above suggestion. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Alabama" wrote: I am having a problem nesting this calculation, in addition the final sum should be rounded to 34k....do not know where I am going wrong Example: Payment Gross Up Sum Rounded 32,549.00 976.47 33,525.47 30,000.00 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! Trying to create a nested formula
And I guess I didn't answer the nesting issue:
=ROUND(SUM(A1:A100),-3) -- If this helps, please click the Yes button Cheers, Shane Devenshire "Alabama" wrote: I am having a problem nesting this calculation, in addition the final sum should be rounded to 34k....do not know where I am going wrong Example: Payment Gross Up Sum Rounded 32,549.00 976.47 33,525.47 30,000.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested formula | Excel Discussion (Misc queries) | |||
can you create nested formulas within v-lookup; if so how | Excel Worksheet Functions | |||
Help with formula €“ too many nested IFs | Excel Worksheet Functions | |||
Nested Formula help | Excel Worksheet Functions | |||
Nested Formula | Excel Worksheet Functions |