Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Financial Accounting

Authors: Fred Phillips, Robert Libby, Patricia A Libby

3rd Edition

0073527106, 9780073527109

More Books

Students also viewed these Accounting questions

Question

3. An initial value (anchoring).

Answered: 1 week ago

Question

4. Similarity (representativeness).

Answered: 1 week ago