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

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 5% or cell C7 is greater than 500, the IF function should multiply the value in cell A1 by the value in cell B1. Otherwise, the function should produce a blank cell. In the space below, enter an IF function using the OR function to produce the outputs described above. Enter 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 General Management Questions!