The MID function in Excel is a function of the Text function group, you use the MID function if you want to cut the string in the middle of the text string when processing the string. If you do not know or do not understand the MID function, you can refer to the article on how to use the MID function with the example illustrated below.
Here the article shares to you the description, syntax and examples of using the MID function, invite you to follow along.
MID function description
The MID function is a function that cuts the string in the middle, returning a specific number of characters from a text string, and the position to cut the string will be specified by you.
The MID function always counts each character as 1, whether it's a single byte or a double byte, regardless of the default language setting?
MID function syntax
= MID (text; start_num; num_chars)
Inside:
Note
MID function example
Example 1: Use the MID function to extract 3 characters in the string 'MID function in Excel' starting at position 5.
You can enter the string directly into the MID function, where start_num is 5 and the number of characters cutting num_chars is 3.
= MID ("MID function in Excel"; 5; 3)
Or you can refer to the cell containing the string to extract.
Example 2: Combine MID function with VLOOKUP, LEFT and IF functions to handle the following data table.
How to handle unit price:
If you do not understand the VLOOKUP function, you can see more about using the VLOOKUP function here http://TipsMake.vn/ham-vlookup-in-excel/
Specifically, you enter the following function formula in cell E6
= VLOOKUP (LEFT (B6; 2); A16: D19; IF (MID (B6; 4; 1) = "S"; 3; 4); 0)
Inside:
Next, if you want to copy the Vlookup function formula with LEFT, IF, MID, then when you enter the Vlookup formula to the wholesale / retail price list A16: A19, press the F4 key to fix this table space. Now the Vlookup function will look like this:
= VLOOKUP (LEFT (B6; 2); $ A $ 16: $ D $ 19; IF (MID (B6; 4; 1) = "S"; 3; 4); 0)
You just need to copy the formula.
To calculate the Thanh Tien column, you only need to use the * operator to multiply the Sales SL by the Found Unit Price and copy the formula down to the cells below. So your data sheet has been processed.
Thus the article has shared syntax, for example, how to use the MID function in Excel. Hopefully through this article, you will better understand the MID function. You can flexibly combine the MID function with other functions so you can get the most out of it. Good luck!
ncG1vNJzZmismaXArq3KnmWcp51kwamxjKagnWWWqrukwMiopWahnmKyua%2FEpWShp6diwbB51KycZqyYmnqutcNmna6mk6m2sLqMmqWdZZWtrq68y56q