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 Ex...

Question

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, ...

Accepted Answer

The Answer is in the image, click to view ...

Question

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

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI