I have try this three different way and still can not come up with the correct answer, could you guide me the right way.
suppose that a spreadsheet contains the following values,
A6, B-4, C2, D3
it said to determine the value of cell E1 if it contains the following formulas.
a +A + B1 than E1 = what
+4*A1+5*B1 than E1 = what
Can you give me some direction Than you
Of course! Let's go step by step to determine the value of cell E1 for each of the given formulas.
Formula 1: a + A + B1
First, let's break down the formula and understand the values it uses:
- "a" is not defined in the question, so let's assume it represents a specific value.
- "A" refers to the value in cell A1, which is A6, according to the given values.
- "B1" refers to the value in cell B1, which is B-4, according to the given values.
To find the value of cell E1 using this formula, we need to substitute the values:
E1 = a + A + B1 = a + A6 + B-4
Formula 2: +4*A1 + 5*B1
Again, let's break down the formula:
- "A1" refers to the value in cell A1, which is A6, as mentioned earlier.
- "B1" refers to the value in cell B1, which is B-4.
To find the value of cell E1 using this formula, we substitute the given values:
E1 = 4*A1 + 5*B1 = 4*A6 + 5*B-4
Now, to determine the actual values, we need to know the specific value of "a" that was given or implied. Once we know that, we can substitute it into the formulas and calculate the values of E1.
Please provide the value of "a" so that I can help you determine the values for E1.