If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Formulas
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. |
#3
|
|||
|
|||
Formulas
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. |
#4
|
|||
|
|||
Formulas
"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. |
#5
|
|||
|
|||
Formulas
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. |
#6
|
|||
|
|||
Formulas
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. |
Thread Tools | |
Display Modes | |
|
|