Cell F7 tells whether or not we own or not own a stock at the beginning of a day

Question

Cell F7 tells whether or not we own or not own a stock at the beginning of a day Cell G7 gives the price of the stock at the end of the day. We decide whether to buy the stock, sell the stock or take no action based on the following rule:

• If end price >=$50 and we own stock we will sell.

• If end price <=$35 and we do not own the stock we will buy.

• Otherwise we take no action.

Choose the formula that will correctly implement this strategy.

A. IF(AND(F7="not own",G7>=50),"sell",IF(AND(F7=" own",G7<=35),"buy","none"))

B. IF(AND(F7="own",G7>=50),"sell",IF(AND(F7="not own",G7<=35),"buy","none"))

C. IF(AND(F7="own",G7>=50),"sell",IF(AND(F7="not own",G7<=35),"sell","none"))

D. IF(F7="own",G7>=50),"sell",IF( (F7="not own",G7<=35),"buy","none"))

E. None of the above

Explanation / Answer

B. IF(AND(F7="own",G7>=50),"sell",IF(AND(F7="not own",G7<=35),"buy","none"))

With this formula all the 3 conditions are being met.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.