Question
have trouble understanding what this question is asking me to do On the Transactions worksheet, click cell U9. Enter an IF function. The logical test
have trouble understanding what this question is asking me to do
On the Transactions worksheet, click cell U9. Enter an IF function. The logical test of the IF function is an OR function where the first logical test is an AND function. The AND function tests to see if the value in cell H9 equals the value of cell I4 on the DataInputs worksheet and if the value in cell P9 is greater than the value of cell J14 on the DataInputs worksheet. Logic2 of the OR function is a second nested AND function that tests to see if the value of cell H9 is equal to the value of cell I13 on the DataInputs worksheet and the value in cell P9 is greater than the value of cell J14 on the DataInputs worksheet. If the value of the logical test is true, the result is 1. If the value is false, the result is 0.
Be sure to use absolute references where necessary to be able to copy the formula to cell U30.
can anyone simplify ?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started