0
How do you write an Excel equation to multiply the first cell in a row by the third cell in a row without directly referencing it such as A1C1?
Wiki User
∙ 14y ago
One method is to use the OFFSET function.
Normally, you would use the following equasion to multiply the contents of A1 and C1 and display the result in E1. In cell E1, enter this formua: =A1*C1
However, if you do not want to reference the cells directly, you can enter the following formula in E1:
=OFFSET(E1,0,-4)*OFFSET(E1,0,-2)
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
You can multiply both sides of a by the same number without changing the value of the?
An 'equation' is a statement that you're given, and you're told that it's true. You can add or subtract the same number to each side of the equation, and you can multiply or divide each side of the equation by the same number, without changing the truth of the statement. These handy operations are the methods you use to tease out the value that the equation's variable must have in order for the statement to be true. (There's no such thing as the 'value' of an equation, only the truth of the equation, and the value of its left side, its right side, and its variable.)
By what number must you multiply each side of the equation 34x9 to produce the equivalent equation x 12?
Without any equality signs the expessions given can't be considered to be equations and therefore have no solutions.
What is the multiplication property of equality words and symbols?
It means that in an equation, you can multiply both sides (left and right of the equal sign) by the same number (except zero), without changing the result set.
Is the equation 4y2x linear?
Without an equality sign it is not an equation but an expression
What is the answer to the equation 5 (-3) x4?
There is no answer because without an equality sign it is not an equation
How do you do the equation x 4-5590?
Without an equality sign it can not be considered to be an equation.
How do you add fractions without mixed numbers?
irregular fractions! ex. if the equation is 2 3/4, you would multiply 2*4, then add three. that is your numerator, denominator will stay the same. it will =11/4
Whats an example of allusion?
An example of allusion is referencing "Romeo and Juliet" in a story about forbidden love, without directly mentioning the play or characters. This allows the reader to draw on their knowledge of the play to better understand the situation in the story.
What are the lines for the equation y2x-4?
6
What is the equation for m-8 (19)?
Without an equality sign it can't be considered to be an equation.
What is the solution of the equation yx³-3?
Without an equality sign the given expression is not an equation
Type this equation in standard form 3x2y 7?
Without an equality sign it is not an equation
