Question: An IF function will be entered into an Excel worksheet to evaluate the contents of two cell locations: A7 and C7. Cell A7 contains the

 An IF function will be entered into an Excel worksheet to

An IF function will be entered into an Excel worksheet to evaluate the contents of two cell locations: A7 and C7. Cell A7 contains the percent change from the cost of an investment to its current value. Cell C7 shows the current profit in dollars for an investment. If either cell A7 is greater than 4% or cell C7 is greater than or equal to 600, the IF function should divide the value in cell A1 by the value in cell B1. Otherwise, the function should leave the cell blank. Write an IF function using the OR function to produce the outputs described above. Write this function as if it is being entered into a cell on an Excel worksheet. An IF function will be entered into an Excel worksheet to evaluate the contents of two cell locations: A7 and C7. Cell A7 contains the percent change from the cost of an investment to its current value. Cell C7 shows the current profit in dollars for an investment. If either cell A7 is greater than 4% or cell C7 is greater than or equal to 600, the IF function should divide the value in cell A1 by the value in cell B1. Otherwise, the function should leave the cell blank. Write an IF function using the OR function to produce the outputs described above. Write this function as if it is being entered into a cell on an Excel worksheet

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!