Question: How to write an IF statement in excel, D2 and E2 both move in the same direction result is 1, but if they move in

How to write an IF statement in excel, D2 and E2 both move in the same direction result is 1, but if they move in the opposite directions (i.e., one moves in the postive and the other moves in the negativr direction) result in 0

2 e eve o p N 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Date S&P 500 10-year Yield S&P + BY +/- IF 12/31/15 2043.94 2.269 -19.42 -0.03 12/30/15 2063.36 2.303 115.00 0.00 12/29/15 2078.36 2.307 21.86 0.08 12/28/15 2056.50 2.225 4.49 -0.02 12/24/15 2060.99 2.243 -3.30 -0.02 12/23/15 2064.29 2.264 25.32 0.02 12/22/15 2038.97 2.239 17.82 0.04 12/21/15 2021.15 2.197 15.60 0.00 12/18/15 2005.55 2.199 -36.34 -0.04 12/17/15 2041.89 2.238 31.18 -0.05 12/16/15 2073.07 2.287 29.66 0.02 12/15/15 2043.41 2.268 21.47 0.04 12/14/15 2021.94 2.225 9.57 0.09 12/11/15 2012.37 2.139 -39.86 -0.10 12/10/15 2052.23 2.239 4.61 0.03 12/9/15 2047.62 2.208 -15.97 -0.03 12/8/15 2063.59 2.238 -13.48 0.01 12/7/15 2077.07 2.225 -14.62 -0.05 12/4/15 2091.69 2.275 42.07 -0.06 12/3/15 2049.62 2.330 -29.89 0.15 12/2/15 2079.51 2.178 -23.12 0.02 12/1/15 2102.63 2.155 22.22 -0.06 11/30/15 2080.41 11/27/15 2090.11 11/25/15 2088.87 11/24/15 2089.14 11/23/15 2086.59 11/20/15 2089.17 11/19/15 2081.24 11/18/15 2083.58 11/17/15 2050.44 11/16/15 2053.19 11/13/15 2023.04 11/12/15 2045.97 11/11/15 2075.00 11/10/15 2081.72 11/9/15 2078.58 11/6/15 2099.20 11/5/15 2099.93 11/4/15 2102.31 11/3/15 2109.79 11/2/15 2104.05 10/30/15 2079.36 10/29/15 2089.41 10/28/15 2090.35 10/27/15 2065.89 36 2.218 2.225 2.232 2.243 2.250 2.262 2.248 2.269 2.261 2.273 2.280 2.319 2.338 2.322 2.342 2.333 2.245 2.230 2.220 2.187 2.151 2.173 2.092 2.028 -9.70 1.24 -0.27 2.55 -2.58 7.93 2.34 33.14 -2.75 30.15 22.93 -29.03 6.72 3.14 -20.62 -0.73 -2.38 -7.48 5.74 24.69 -10.05 -0.94 24.46 -5.29 -0.01 -0.01 -0.01 -0.01 -0.01 0.01 -0.02 0.01 -0.01 -0.01 -0.04 -0.02 0.02 -0.02 0.01 0.09 0.02 0.01 0.03 0.04 -0.02 0.08 37 38 39 40 42 43 44 45 46 47 48 0.06 -0.03 2 e eve o p N 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Date S&P 500 10-year Yield S&P + BY +/- IF 12/31/15 2043.94 2.269 -19.42 -0.03 12/30/15 2063.36 2.303 115.00 0.00 12/29/15 2078.36 2.307 21.86 0.08 12/28/15 2056.50 2.225 4.49 -0.02 12/24/15 2060.99 2.243 -3.30 -0.02 12/23/15 2064.29 2.264 25.32 0.02 12/22/15 2038.97 2.239 17.82 0.04 12/21/15 2021.15 2.197 15.60 0.00 12/18/15 2005.55 2.199 -36.34 -0.04 12/17/15 2041.89 2.238 31.18 -0.05 12/16/15 2073.07 2.287 29.66 0.02 12/15/15 2043.41 2.268 21.47 0.04 12/14/15 2021.94 2.225 9.57 0.09 12/11/15 2012.37 2.139 -39.86 -0.10 12/10/15 2052.23 2.239 4.61 0.03 12/9/15 2047.62 2.208 -15.97 -0.03 12/8/15 2063.59 2.238 -13.48 0.01 12/7/15 2077.07 2.225 -14.62 -0.05 12/4/15 2091.69 2.275 42.07 -0.06 12/3/15 2049.62 2.330 -29.89 0.15 12/2/15 2079.51 2.178 -23.12 0.02 12/1/15 2102.63 2.155 22.22 -0.06 11/30/15 2080.41 11/27/15 2090.11 11/25/15 2088.87 11/24/15 2089.14 11/23/15 2086.59 11/20/15 2089.17 11/19/15 2081.24 11/18/15 2083.58 11/17/15 2050.44 11/16/15 2053.19 11/13/15 2023.04 11/12/15 2045.97 11/11/15 2075.00 11/10/15 2081.72 11/9/15 2078.58 11/6/15 2099.20 11/5/15 2099.93 11/4/15 2102.31 11/3/15 2109.79 11/2/15 2104.05 10/30/15 2079.36 10/29/15 2089.41 10/28/15 2090.35 10/27/15 2065.89 36 2.218 2.225 2.232 2.243 2.250 2.262 2.248 2.269 2.261 2.273 2.280 2.319 2.338 2.322 2.342 2.333 2.245 2.230 2.220 2.187 2.151 2.173 2.092 2.028 -9.70 1.24 -0.27 2.55 -2.58 7.93 2.34 33.14 -2.75 30.15 22.93 -29.03 6.72 3.14 -20.62 -0.73 -2.38 -7.48 5.74 24.69 -10.05 -0.94 24.46 -5.29 -0.01 -0.01 -0.01 -0.01 -0.01 0.01 -0.02 0.01 -0.01 -0.01 -0.04 -0.02 0.02 -0.02 0.01 0.09 0.02 0.01 0.03 0.04 -0.02 0.08 37 38 39 40 42 43 44 45 46 47 48 0.06 -0.03

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Complete excel worksheet. Use video if necessary. https://www.youtube.com/watch?v=Q7uniN25vno Analyzing Historical Risk vs. Return for a Company. Choose a company that you are using in the investment...

Using Exhibits 6.4 and 6.5 from Chapter 6 in your textbook as guidelines, respond to the following statements. You are not required to submit the responses, but use your answers as the foundation for...

Skeleton Code: #include #define SIZE 4 #define LENGTH 21 void readGrid(int [][SIZE]); void printGrid(int [][SIZE]); int main(void) { int grid[SIZE][SIZE], target; char directions[LENGTH];...

Question 3 (1 point) Figure 2-4 25 20 15 10 20 30 40 50 so zo Refer to Figure 2-4. Suppose the economy is at point A. What is the opportunity cost of increasing the production of toothbashes by 20...

K L M N O I J Ahalyzing Historical Risk vs. Return for a Company. Choose a company that you are using in the investment challenge and complete the following steps. Print these instructions and follow...

Learning Objectives 3-1 By the end of this section, you will be able to: Explain demand, quantity demanded, and the law of demand Identify a demand curve and a supply curve Explain supply, quantity...

The experimental result differs from the assumption. The result shows that the ring oscillator frequencies can be grouped into two groups, where the first group is the high frequency group for the...

DVD players coming off an assembly line are automatically checked to make sure they are not defective. The manufacturer wants an interval estimate of the percentage of DVD players that fail the...

An interesting company to consider from both corporate structure and valuation perspectives is Facebook Inc. The social networking company was originally created by Mark Zuckerberg in February 2004,...

Part 1 Which statements are true according to the CAPM? Check all that apply: The expected return on an asset is based on its total risk. Firm - specific risk is irrelevant when determining an...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Assume that you are preparing a visual aid that will not fit on the page with the text that relates to it. Where would you place this visual aid in the report? (Objective 2)

Construct a graph for the following data. Include appropriate content, placement, and format for the number of the visual (assume it is the first visual in a report), title, and source note. Assume...

You have several items to compare differences in quantities. What type of graph would you prepare? Why? (Objective 4)