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.

• IF(AND(F7="not own",G7>=50),"sell",IF(AND(F7=" own",G7<=35),"buy","none"))
• IF(AND(F7="own",G7>=50),"sell",IF(AND(F7="not own",G7<=35),"buy","none"))
• IF(AND(F7="own",G7>=50),"sell",IF(AND(F7="not own",G7<=35),"sell","none"))
• IF(F7="own",G7>=50),"sell",IF( (F7="not own",G7<=35),"buy","none"))
• None of the above