Enter a formula that references the value in cell f10

Asked by admin @ 29/10/2021 in Mathematics viewed by 285 People

In Microsoft Excel, you have data that has been entered into cell A1. You need a function that looks up this value from A1 in a table of values in E1 through F10. You need to have the value from the second column (F) be displayed in the cell in which you are writing this formula. Also, A1 will precisely match one of the values in the first column (E). What formula would you write to look up this information?

Answered by admin @ 29/10/2021

I'm going to assume that there is something in A1 but the way you are describing the problem, you could just as easily write a constant in the formula you are using in cells E1 to E10 and F1 to F10

The trick is to refer to A1 as $A$1 which means that E1 to E10 isn't going to get creative and start looking for things in a1 to a10.

Here is an actual table made from what I think you mean

1 113 114

2 114 116

3 115 118

4 116 120

5 117 122

6 118 124

7 119 126

8 120 128

9 121 130

10 122 132

1 to 10 on the left is in column D

A1 contains 112

In column E the enteries from 1 to 10 simply take = $A$1 + d1

Column F uses $A$1 and adds 2*d to 112

Here is the chart shown in formula form.

1 =D1+$A$1 =$A$1 + 2*D1

2 =D2+$A$1 =$A$1 + 2*D2

3 =D3+$A$1 =$A$1 + 2*D3

4 =D4+$A$1 =$A$1 + 2*D4

5 =D5+$A$1 =$A$1 + 2*D5

6 =D6+$A$1 =$A$1 + 2*D6

7 =D7+$A$1 =$A$1 + 2*D7

8 =D8+$A$1 =$A$1 + 2*D8

9 =D9+$A$1 =$A$1 + 2*D9

10 =D10+$A$1 =$A$1 + 2*D10

Remember that 1 to 10 is in d1 to d10

Enter a formula that references the value in cell f10

Similar Questions

Westernization refers to countries adopting the culture and values of

When water enters the guard cells the stomata

What 4 items can be entered into a spreadsheet cell

Using a cell address in a formula is known as

To enter or leave a cell substances must pass through

Used to help substances enter or exit the cell membrane

The energy value listed for foods refers to the _______

What is the value of x? enter your answer in the box.

What is the value of x? enter your answer in the box. x =

The term daily value on a food label refers to

Which of the following is an absolute cell reference

What symbol is used to designate an absolute cell reference

Difference between absolute cell reference and relative cell reference

All chemical reactions within a cell are referred to as

Which technique used to allow only date value in cell?

Most viewed questions in Mathematics

Unit 6 similar triangles homework 2 similar figures answer key

All things algebra unit 7 polygons and quadrilaterals answer key

Gina wilson all things algebra 2016 answer key unit 11

Unit 1 geometry basics homework 4 angle addition postulate answers

Unit 6 exponents and exponential functions homework 8 answer key

The manager of a vacation resort believes that the ages

What is 271 403 rounded to the nearest ten thousand

Unit 1 geometry basics homework 3 angle relationships answer key

Homework 2 parallelograms

Why would a prism beat a sphere in a competition?

John wants to send a letter to peter

An artist sells a painting for 20.50 but uses 5.75

Unit 4 congruent triangles homework 1 classifying triangles answer key

Unit 4 congruent triangles homework 2 angles of triangles

Compare the values of the 2s and 5s in 55220