In cell J5, insert a formula using the AND function that returns TRUE if the reordering indicator (cell I5) is equal to "N" and if the days in inventory (cell H5) is greater than 40. Use the Fill Handle to fill the range J6:J15 with the formula in cell J5, filling the range without formatting.

Q&A Education