IFS function is new to Excel, it is important that you understand how to solve problems nesting
Question:
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 there order 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.
Introduction to Management Accounting
ISBN: 978-0133058789
16th edition
Authors: Charles Horngren, Gary Sundem, Jeff Schatzberg, Dave Burgsta