Welcome Guest.

2Answers

Under the teachings of the great god, I use a function to extract the specified number of conditions from the cell, as if the medical insurance reimbursement in the following text is to be reimbursed for reimbursement

Asked by: Donald Hill 16 views IT August 18, 2022

A total of 4990.67 yuan in hospitalization costs, 3541.77 yuan for medical insurance reimbursement, and the actual cost of the family for 1448.9 yuan.The position in the form is not fixed

2 Answers

  1. +3Votes  

    Formula = MID (A1, Find (“Medical Insurance Reimbursement”, A1)+4, Find (“Family”, A1) -2-Find (“Medical Insurance Reimbursement”, A1) -4) Unit

    Question: The effect I want is that after using the formula, the query result is 3541.11

    Answer: Trial, result 3541.77

    Susan Williams- August 18, 2022 |

  2. +2Votes  

    “Form” Table What does it mean to do not fixed “?

    1. Are these contents (inpatient costs totaling 4990.67 yuan, medical insurance reimbursement of 3541.77 yuan, and the actual cost of the household paid 1448.9 yuan.) Maybe it is within which cells.

    2. Whether its content is not allowed to be the same, or it may be:

    The hospitalization cost is 4990.67 yuan, the actual cost of the family is 1448.9 yuan, and the medical insurance reimbursement is 3541.77 yuan.

    or

    Medical insurance reimbursement is 3541.77 yuan, the actual cost of the family is 1448.9 yuan, and the hospitalization cost is 4990.67 yuan.

    or

    The actual cost of the family is 1448.9 yuan, the medical insurance reimbursement is 3541.77 yuan, and the hospitalization cost is 4990.67 yuan.

    Question: The position of the table is not fixed. My expression is wrong. It should be that this sentence is in different positions of the cell. It may be in the first half, it may be in the middle, and it may be in the second half. The effect to be achieved is that after using the formula, the amount of medical insurance reimbursement can be quered. As the result of this sentence is 3541.11

    Answer: After the formula is entered in the following formula, it can be quickly filled down (see the figure Show).
    = Left (MID (A2, Find (“Sales”, A2)+1,10^8),
    Find (“Yuan”, MID (A2, Find (“Sales”, A2)+1,10^8)-1)

    Jason Clark- August 18, 2022 |