Want this question answered?
It is 71, as stated in the question.
4 = 25 - 7y if you need the value of y, transpose -7y to the left side (it will become 7y). transpose 4 to the right side (it will become -4) here it is: 7y = 25-4 7y = 21 divide both sides by 7. y = 3 that's all.
a value formula
'How do you do formulas on excel and continue to work with answer as a numerical value and not a formula '
No, it is an integer. You can save an integer value to a string variable but, in this case the value is explicitly stated to be 3.
1 kW = 1000 watts. Formula is Watts = Amps x Volts. As you can see to give you a answer I need a value for volts. Transpose the formula to read I = 1000/volts.
I assume the original question was how to reverse value from a row into a column format You paste special then transpose. If the value are result of a formula attention at the references, you may need to use the option past value too L
You can use the TRANSPOSE function, entering it as an Array function. So if you have something in A2 and A3, you could select C2 and D2 and type the following function: =TRANSPOSE(A2:A3) Instead of pressing Enter, press Ctrl-Shift-Enter and it will enter the formula into the two cells, C2 and D2, and transpose the values. You can apply the same principle to larger ranges. There are also other ways of doing it, like using the INDIRECT function to reference a cell and get its value.
There are zero watts for 4000 amps. The formula for watts is; W = A x V, so you see a value for voltage has to be stated to give an answer.
Many auto insurers will carry a stated value policy on the car. Stated value requires photos and appraisals. A value is established and you can be insured for all perils up to that stated amount.
The Formula Bar.
It is 71, as stated in the question.
total equity/# of shares outstanding
4 = 25 - 7y if you need the value of y, transpose -7y to the left side (it will become 7y). transpose 4 to the right side (it will become -4) here it is: 7y = 25-4 7y = 21 divide both sides by 7. y = 3 that's all.
a value formula
The proper name is the formula bar, but yes a formula or value can be seen there when you have entered a value or formula in a cell.
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.