Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel Question: create a IFS function and satisfiy three requirements at the same time If J is FALSE, return HOLD If J and K are
Excel Question: create a IFS function and satisfiy three requirements at the same time
If J is FALSE, return HOLD
If J and K are TRUE, return SHIP
If C>=5 and J are TRUE, but K is FALSE, return SHIP
Example: IFS(J = "FALSE", "HOLD", AND(J, K), "SHIP", AND(C>=5, J), "SHIP")
Please help editing requirement 3, which is incomplete.
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