Enter a formula in cell j4 using the if function to it


What is the IF formula?

  1. Enter a formula in cell J4 using the IF function to it whether or not the item Beaded Earrings should go on sale. It will go on sale if its current sales rank (in cell G4) is 8th or lower. (Hint: If the cell value is greater than or equal to 8, it will go on sale.)

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 on sale. (Hint: The if_false value should be "-".)

Solution Preview :

Prepared by a verified Expert
Finance Basics: Enter a formula in cell j4 using the if function to it
Reference No:- TGS02657577

Now Priced at $10 (50% Discount)

Recommended (95%)

Rated (4.7/5)