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  |