Formulas

  • Thread starter Thread starter formulaconfusion
  • Start date Start date
F

formulaconfusion

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.
 
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
 
formulaconfusion said:
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
Click to expand...

=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 -----
 
I said:
=B6*(1+C4)
or
=B6 + B6*C4
Click to expand...

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 -----
 
Back
Top