Formula to subtract from a cell given a set number range

[ClashGordon]

Good morning and newbie here. Not sure if I worded the title correctly but hopefully I can describe it better. So I have an age range starting with 62 on up. The formula I am looking for would start with a set number (in this case 29), subtract a year based on the person's age as they get older and that number has to go down to 10 (age 81 is where 10 kicks in). After that age/year hits 10, any other age past that will stay at 10. See example. Thank you for any help in the matter.


Age Year
62 29
63 28
64 27
... ...
81 10
82 10
83 10

 

[Dave Patton]

Excel 2010
	A	B
1	Age	Year
2	62	29
3	63	28
3d

Cell Formulas
Range	Formula
B3	=MAX(10,B2-(A3-A2))

 

[ClashGordon]

Thank you for the reply. One thing I forgot to mention is that column B is not in the data. I need column B to be the results if that makes sense. So if age is 62, I need cell B2 to be 29, if the age is 63, I need it to be 28. I was thinking about just building a table and doing a vlookup. But regardless, thanks for all your help.