Question
Can anyone help me with excel? The actual textbook question is posted below which i know might not be enough info but if anyone has
Can anyone help me with excel? The actual textbook question is posted below which i know might not be enough info but if anyone has an example of a nested if and and funtion it would help som much! Thanks
On the Inventory worksheet, click cell L19, and enter a nested IF and AND function to determine the reorder status. If the current inventory in cell H19 is blank and the reorder point in I19 is blank, then a blank value should be returned. If not, then if Discontinue in K19 is equal to N and current inventory is less than or equal to the rush reorder point in J19, Rush should be returned. If not, then if Discontinue is equal to N and current inventory is less than the reorder point, return the value of Reorder, or else OK. Copy the formula down the column.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started