(Solved) : Geneva S Manager Would Like See Additional Information Help Make Sales Decisions Enter For Q35399670 . . .
- Geneva’s manager would like to see some additional informationto help make sales decisions.
Enter a formula in cell J4 using theIF function to it whether or not the item BeadedEarrings should go on sale. It will go on sale if its current salesrank (in cell G4) is 8th or lower. (Hint: Ifthe cell value is greater than or equal to 8, it will go onsale.)
- If this condition is true, the item will go on sale.(Hint: The if_true value should be “YES”.)
- If this condition is false, the item doesn’t need to go onsale. (Hint: The if_false value should be “-”.)
- Copy the formula created in cell J4 to the range J5:J14.
Expert Answer
Answer to Geneva S Manager Would Like See Additional Information Help Make Sales Decisions Enter For Q35399670 . . .
OR