questions with if statements and nested if statements

I have a set of data and I am looking for some help with several ways I have to break the data down;

Using =IF(), transform *** into a 1 if *** is F and a 0 if *** is M. Call this Sex1. *** is broken down in cells c2-c21

Using nested =IF(), transform age to another variable that combines age into ten-year age groups, beginning with the youngest age among the patients listed. Assign 1 to the youngest group. Call this Age1. Age is broken down in cells b3-b21 and the youngest age is 21

Using nested =IF(), transform age to another variable that combines age into ten-year age groups, beginning at birth. Assign 1 to the youngest age group. Call this Age2. age is broken down in cells b3-b21

Using nested =IF(), transform the variable Insurance into a new variable called Insurance1—that is, 1 if the insurance type is Medicaid, 2 if the insurance type is BCBS, 3 if the insurance type is private, and 4 for self-pay. Insurance is broken down in cells h2-h21

Using nested =IF(), transform the variable Prior into a variable called Prior1, where no prior visits is coded None, 1 to 2 prior visits is coded Low, 3 to 4 prior visits is coded Medium, and 5 or 6 prior visits is coded High. Prior is broken down in cells i2-i21


thanks for the help!

Unfortunately it has to be if functions so any help would be appreciated

No i completely hear you but it has to if functions, thanks for your help!

Here's a file with the data, and it has to if functions because that is how the questions are being asked, thanks for the help!

for the age question i believe age 1 is for the starting age in the data set while for age 2 it starts at 0 and goes from 0 as the starting point

Thanks for all your help, really appreciate it

It was the way the question was asked, I'm sure there are easier ways to do it but thank you again