How do I recode the dataset for salary in excel? [Problem says: change Salary to be categorical with categories Less than $40K, Between $40K and $70K, Between $70K and $100K, and Greater than $100K (where you can treat the breakpoints however you like).]

I was able to figure out the code for "Less than $40K" and "Greater than $100K," but I am having trouble with the between salary ranges. I did figure out using the ">" and " Person Gender Children Salary Opinion $63,017Strongly agree Middle-aged Middle-aged Middle-aged Young Middle-aged Middle-aged Middle-aged Middle-aged Middle-aged Middle-aged Texas Virginia California California Texas California 3 $100,302 Strongly disagree 0$144,043Strongly agree 0 0 $36,025 S97,543 $69,222 $81,799 Neutral Disagree Disagree 1 gan 1 $101,894 0 Texas Virginia Illinois Arizona Arizona Minnesota Texas Texas $83,843Strongly disagree $87,457 9 Agree Disagree Disagree 0 $48,966 $88,855 Middle-aged Middle-aged 1$115,138 Strongly agree S67,748 $47,172 $39,086 Neutral Young Middle-aged Middle-aged Elderly Disagree Disagree Neutral Disagree 0 0$126,983 Texas California Florida Illinois $66,001 S67,723 $53,335Strongly disagree $67,683 $45,483 $64,364 Young Elderly Neutral Disagree 0 2$102,315 2$93,370 2$148,075 0 Texas Middle-aged Middle-aged Middle-aged Middle-aged Neutral Strongly agree Disagree Michigan Arizona S97,857 $62,929Strongly agree $37,963Strongly disagree $76,476Strongly agree $81,674Strongly disagree S49,505 Strongly disagree Illinois California Young Middle-aged Middle-aged Young Young Texas California Arizona 3$49,723 0 Strongly disagree $81,981 S66,636 Elderly gree