Since the IFS function is new to Excel, it is important that you understand how to solve problems nesting IF functions together, as many organizations may not have the most up to date version of the software. On the Inventory worksheet, enter a nested IF formula into cell L2 to determine the reorder status based on the following . A blank should be returned if the current inventory and reorder point are both blank Rush should be returned if the Discontinue value is N and current inventory is less than or equal to the rush reorder point Reorder should be returned if the Discontinue value is equal to N and current inventory is less than the reorder point For all others, OK should be returned. -Fill the formula down through cell L21