Phoebe8178
New Member
- Joined
- Sep 22, 2002
- Messages
- 17
I am attempting to set up a spreadsheet for life insurance policies. There are three age groups that will get a rate. I cannot figure out how to get a formula for this. I figured out the basic formula =IF(A2>=49,"$3.00","N/A". But I want to develop something that will allow me to put a range in where the 49 is. For example if the age groups are 18-49, 50-59, 60-64, I want to develop a formula that will allow me to just drop in the age and have the correct rate prop up. I really need help with this!!!