Formulas

How do I create a formula for this? Multiply the base value in cell B6 times
100% plus the value in cell C4. Place the second expression in parentheses so
that addition is performed first and make the reference to the value in C4
absolute so that this formula can be copied down column c.

Hi,

=B6*((100+$C$4)/100)

or

=B6*(1+$C$4/100)


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"formulaconfusion" wrote:

How do I create a formula for this? Multiply the base value in cell B6 times
100% plus the value in cell C4. Place the second expression in parentheses so
that addition is performed first and make the reference to the value in C4
absolute so that this formula can be copied down column c.

I am soooooo confused. This is what is in my textbook.
B6 is 1667164
C4 is 3.75%
the answer is 1,729,683 and I need to figure out the formula to get the answer

"Mike H" wrote:

Hi,

=B6*((100+$C$4)/100)

or

=B6*(1+$C$4/100)


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"formulaconfusion" wrote:

How do I create a formula for this? Multiply the base value in cell B6 times
100% plus the value in cell C4. Place the second expression in parentheses so
that addition is performed first and make the reference to the value in C4
absolute so that this formula can be copied down column c.

"formulaconfusion" wrote:
I am soooooo confused. This is what is in my textbook.
B6 is 1667164
C4 is 3.75%
the answer is 1,729,683 and I need to figure out
the formula to get the answer

=B6*(1+C4)

or

=B6 + B6*C4

Note: If you change the format to Number with 2 or more decimal places, you
will see that the actual result is 1,729,682.65. If that is undesirable, you
might want to round explicitly. For example:

=ROUND(B6*(1+C4),0)


----- original message -----

"formulaconfusion" wrote:

I am soooooo confused. This is what is in my textbook.
B6 is 1667164
C4 is 3.75%
the answer is 1,729,683 and I need to figure out the formula to get the answer

"Mike H" wrote:

Hi,

=B6*((100+$C$4)/100)

or

=B6*(1+$C$4/100)


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"formulaconfusion" wrote:

How do I create a formula for this? Multiply the base value in cell B6 times
100% plus the value in cell C4. Place the second expression in parentheses so
that addition is performed first and make the reference to the value in C4
absolute so that this formula can be copied down column c.

I wrote:
=B6*(1+C4)
or
=B6 + B6*C4

Just saw this detail from the original posting: "make the reference to the
value in C4 absolute".

So change C4 to $C$4.


----- original message -----

"Joe User" wrote:
"formulaconfusion" wrote:
I am soooooo confused. This is what is in my textbook.
B6 is 1667164
C4 is 3.75%
the answer is 1,729,683 and I need to figure out
the formula to get the answer

=B6*(1+C4)

or

=B6 + B6*C4

Note: If you change the format to Number with 2 or more decimal places, you
will see that the actual result is 1,729,682.65. If that is undesirable, you
might want to round explicitly. For example:

=ROUND(B6*(1+C4),0)


----- original message -----

"formulaconfusion" wrote:

I am soooooo confused. This is what is in my textbook.
B6 is 1667164
C4 is 3.75%
the answer is 1,729,683 and I need to figure out the formula to get the answer

"Mike H" wrote:

Hi,

=B6*((100+$C$4)/100)

or

=B6*(1+$C$4/100)


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"formulaconfusion" wrote:

How do I create a formula for this? Multiply the base value in cell B6 times
100% plus the value in cell C4. Place the second expression in parentheses so
that addition is performed first and make the reference to the value in C4
absolute so that this formula can be copied down column c.

Thank you so much. It worked and am on my way to completing the assignment.

"Joe User" wrote:

"formulaconfusion" wrote:
I am soooooo confused. This is what is in my textbook.
B6 is 1667164
C4 is 3.75%
the answer is 1,729,683 and I need to figure out
the formula to get the answer

=B6*(1+C4)

or

=B6 + B6*C4

Note: If you change the format to Number with 2 or more decimal places, you
will see that the actual result is 1,729,682.65. If that is undesirable, you
might want to round explicitly. For example:

=ROUND(B6*(1+C4),0)


----- original message -----

"formulaconfusion" wrote:

I am soooooo confused. This is what is in my textbook.
B6 is 1667164
C4 is 3.75%
the answer is 1,729,683 and I need to figure out the formula to get the answer

"Mike H" wrote:

Hi,

=B6*((100+$C$4)/100)

or

=B6*(1+$C$4/100)


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"formulaconfusion" wrote:

How do I create a formula for this? Multiply the base value in cell B6 times
100% plus the value in cell C4. Place the second expression in parentheses so
that addition is performed first and make the reference to the value in C4
absolute so that this formula can be copied down column c.