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

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

+3

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

Susan Williams- August 18, 2022 |

+2

Votes“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.

Jason Clark- August 18, 2022 |