formula using multiple criteria

[smallball91]

I am looking to create a formula for HSA contributions. I'd like to take the information below and return the value if the Type is something and the Age is under or over 55 then the Limit is determined. Any help is appreciated. thanks!

Type	Limit	Age
single	3400​	36​
single over 50	4400​	35​
family	7500​	55​
family over 50	7600​	60​

 

[dreid1011]

I don't follow what information you are starting with and what information should be the result. Could you provide some sample data showing what information you start with, and what the expected results should be?

 

[smallball91]

I don't follow what information you are starting with and what information should be the result. Could you provide some sample data showing what information you start with, and what the expected results should be?

I'm trying to deliver a result that says if the age is under 50 and the type is single then the result should be 3400 but if the age is over 50 then the result should be 4400 and same with family and family over 50. So, if the age is 36 and the type is single then the result would be 3400, but if the age is 55 and the type is family then the result is 7500. I hope that's clearer.

 

[dreid1011]

Perhaps something like this then:

Book1 1-4-2024.xlsx
	A	B	C	D	E	F	G
1	Type	Limit	Age		Type	Age	Limit
2	single	3400	50		Single	51	Invalide Type/Age Combination
3	single over 50	4400	51		Single	45	3400
4	family	7500	50		Single Over 50	35	Invalid Type/Age Combination
5	family over 50	7600	51		Single Over 50	60	4400
6					Family	70	Invalide Type/Age Combination
7					Family	28	7500
8					Family Over 50	33	Invalid Type/Age Combination
9					Family Over 50	52	7600
Sheet8

Cell Formulas
Range	Formula
G2:G9	G2	=IF(F2>50,IF(E2="Single Over 50",$B$3,IF(E2="Family Over 50",$B$5,"Invalide Type/Age Combination")),IF(E2="Single",$B$2,IF(E2="Family",$B$4,"Invalid Type/Age Combination")))

You can replace the text string "Invalid Type/Age Combination" if the Type/Age doesn't match the constraints.