Prev: Write a Formula
Next: Conditional Formatting for one cell matching another with text
From: formulaconfusion on 14 Feb 2010 15:47
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.
First  |  Prev  | 
Pages: 1 2
Prev: Write a Formula
Next: Conditional Formatting for one cell matching another with text