Formulas
in [Functions]
|
From: formulaconfusion on 14 Feb 2010 15:05 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.
From: Mike H on 14 Feb 2010 15:18 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.
From: formulaconfusion on 14 Feb 2010 15:26 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.
From: Joe User on 14 Feb 2010 15:37 "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.
From: Joe User on 14 Feb 2010 15:41 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.
|
Next
|
Last
Pages: 1 2 Prev: Write a Formula Next: Conditional Formatting for one cell matching another with text |