Nesting help
 

I am trying to nest the calculation of the gross up and the rounding,
following is an example as well as the formula that I am receiving the error
on, also I do not know why my final rounded figure did not round up to 34K?

Example:

Payment Gross Up Sum Rounded
32,549.00 976.47 33,525.47 30,000.00

=SUM(B2*3%,ROUND(B2,1-LEN(INT(B2))))

Nesting help
 

Why are you starting a new thread? Did you look at the answer in the previous
one?

"Alabama" wrote:

I am trying to nest the calculation of the gross up and the rounding,
following is an example as well as the formula that I am receiving the error
on, also I do not know why my final rounded figure did not round up to 34K?

Example:

Payment Gross Up Sum Rounded
32,549.00 976.47 33,525.47 30,000.00

=SUM(B2*3%,ROUND(B2,1-LEN(INT(B2))))

Nesting help
 

Sorry....I was trying to give a better description of my problem, I provided
a copy of mu formula to show what I am trying to accomplish.

"Mike H" wrote:

Why are you starting a new thread? Did you look at the answer in the previous
one?

"Alabama" wrote:

I am trying to nest the calculation of the gross up and the rounding,
following is an example as well as the formula that I am receiving the error
on, also I do not know why my final rounded figure did not round up to 34K?

Example:

Payment Gross Up Sum Rounded
32,549.00 976.47 33,525.47 30,000.00

=SUM(B2*3%,ROUND(B2,1-LEN(INT(B2))))

Nesting help
 

The further description clarified little. from what I can see

A2 B2 C2
32,549.00+976.47= 33,525.47

If that's correct then what do you want to do with C2? Always round Up?
Down? Nearest 1000? or is it none of those?

Mike

"Alabama" wrote:

Sorry....I was trying to give a better description of my problem, I provided
a copy of mu formula to show what I am trying to accomplish.

"Mike H" wrote:

Why are you starting a new thread? Did you look at the answer in the previous
one?

"Alabama" wrote:

I am trying to nest the calculation of the gross up and the rounding,
following is an example as well as the formula that I am receiving the error
on, also I do not know why my final rounded figure did not round up to 34K?

Example:

Payment Gross Up Sum Rounded
32,549.00 976.47 33,525.47 30,000.00

=SUM(B2*3%,ROUND(B2,1-LEN(INT(B2))))

Nesting help
 

You didn't ask the formula to round the final result. Assuming that your
32549 is what is in B2, you have asked for that to be rounded to -4 places
(1 significant figure), so that gave 30000. You've added that to 3% of
32549, so the answer would be 30967.47.

If you wanted to do something entirely different, and add B2*3% to B2, then
round that result to *two* significant figures, it would be
=ROUND(B2+B2*3%,2-LEN(INT(B2))) or
=ROUND(SUM(B2,B2*3%),2-LEN(INT(B2)))
--
David Biddulph

"Alabama" wrote in message
...
I am trying to nest the calculation of the gross up and the rounding,
following is an example as well as the formula that I am receiving the
error
on, also I do not know why my final rounded figure did not round up to
34K?

Example:

Payment Gross Up Sum Rounded
32,549.00 976.47 33,525.47 30,000.00

=SUM(B2*3%,ROUND(B2,1-LEN(INT(B2))))

Nesting help
 

in "C2" I would like onenested formula that takes A2 times 3%, then that sum
is then rounded to nearest ten thousands

"Mike H" wrote:

The further description clarified little. from what I can see

A2 B2 C2
32,549.00+976.47= 33,525.47

If that's correct then what do you want to do with C2? Always round Up?
Down? Nearest 1000? or is it none of those?

Mike

"Alabama" wrote:

Sorry....I was trying to give a better description of my problem, I provided
a copy of mu formula to show what I am trying to accomplish.

"Mike H" wrote:

Why are you starting a new thread? Did you look at the answer in the previous
one?

"Alabama" wrote:

I am trying to nest the calculation of the gross up and the rounding,
following is an example as well as the formula that I am receiving the error
on, also I do not know why my final rounded figure did not round up to 34K?

Example:

Payment Gross Up Sum Rounded
32,549.00 976.47 33,525.47 30,000.00

=SUM(B2*3%,ROUND(B2,1-LEN(INT(B2))))

Nesting help
 

Maybe this

=ROUND((A2*1.03)/1000,0)*1000

I'm sure you mean rounded to nearest 1000 not 10000

Mike

"Alabama" wrote:

in "C2" I would like onenested formula that takes A2 times 3%, then that sum
is then rounded to nearest ten thousands

"Mike H" wrote:

The further description clarified little. from what I can see

A2 B2 C2
32,549.00+976.47= 33,525.47

If that's correct then what do you want to do with C2? Always round Up?
Down? Nearest 1000? or is it none of those?

Mike

"Alabama" wrote:

Sorry....I was trying to give a better description of my problem, I provided
a copy of mu formula to show what I am trying to accomplish.

"Mike H" wrote:

Why are you starting a new thread? Did you look at the answer in the previous
one?

"Alabama" wrote:

I am trying to nest the calculation of the gross up and the rounding,
following is an example as well as the formula that I am receiving the error
on, also I do not know why my final rounded figure did not round up to 34K?

Example:

Payment Gross Up Sum Rounded
32,549.00 976.47 33,525.47 30,000.00

=SUM(B2*3%,ROUND(B2,1-LEN(INT(B2))))

Nesting help
 

thank you, that is excatly what I needed!

"David Biddulph" wrote:

You didn't ask the formula to round the final result. Assuming that your
32549 is what is in B2, you have asked for that to be rounded to -4 places
(1 significant figure), so that gave 30000. You've added that to 3% of
32549, so the answer would be 30967.47.

If you wanted to do something entirely different, and add B2*3% to B2, then
round that result to *two* significant figures, it would be
=ROUND(B2+B2*3%,2-LEN(INT(B2))) or
=ROUND(SUM(B2,B2*3%),2-LEN(INT(B2)))
--
David Biddulph

"Alabama" wrote in message
...
I am trying to nest the calculation of the gross up and the rounding,
following is an example as well as the formula that I am receiving the
error
on, also I do not know why my final rounded figure did not round up to
34K?

Example:

Payment Gross Up Sum Rounded
32,549.00 976.47 33,525.47 30,000.00

=SUM(B2*3%,ROUND(B2,1-LEN(INT(B2))))