Question: In the Separated Data2 sheet, create a formula to extract out the PlantID from the EmployeeCode. in this formula use only the IF, ISNUMBER,

In the Separated Data2 sheet, create a formula to extract out thePlantID from the EmployeeCode. in this formula use only the IF, ISNUMBER,

In the Separated Data2 sheet, create a formula to extract out the PlantID from the EmployeeCode. in this formula use only the IF, ISNUMBER, VALUE, MID, and FIND functions. Hint: When constructing the formula, you will use the IF function as the main overarching formula. The first of the three requirements should be a formula to test if the 2nd character after the hyphen is a number or not (i.e., using the ISNUMBER, VALUE, MID, and FIND functions). The second part of the IF function is the true condition (i.e., a number was found indicating a two-digit PlantID) so this part should return the two-digit number (i.e., using the MID and FIND functions). The third or last part is the false condition to the IF function indicating that a single digit PlantID was found and this formula should return a single digit as a result (i.e., using the MID and FIND functions).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!