IF(AND Statement Help

[hkydad]

I have a table with multiple columns of data and I need some assistance returning a "True", or a "False" based on certain criteria. What I am trying to do is get the IF statement to return a True or False based on certain criteria, such as If column A is New or Used, and column B is >= 18, the statement should return True, if not then False. What I have come up with so far is the following. I'm sure it is something simple I am missing but any help would be greatly appreciated.

IF(OR(A="New","Used"),IF(B>=18),"True","False")

Used 15
New 20
Borrowed 37
New 8
Used 12
Totaled 28
New 41
Borrowed 35

 

[hkydad]

I apologize, the table I typed in did not come out as expected.

The Labels are in Column A
The #'s are in column B

 

[kweaver]

It would help if you changed your profile and indicated what version of Excel you use.

Is this what you mean?

Book1
	A	B	C
2	New	25	True
3	New	17	False
4	Used	19	True
5	New	24	True
6	New	15	False
7	Used	17	False
8	New	20	True
9	Used	14	False
10	Used	17	False
11	Used	14	False
Sheet6

Cell Formulas
Range	Formula
C2:C11	C2	=IF(AND(OR(A2="New",A2="Used"),B2>=18),"True","False")

 

[Fluff]

Another option

=AND(OR(A2={"new","Used"}),B2>18)

 

[hkydad]

It would help if you changed your profile and indicated what version of Excel you use.

Is this what you mean?

Book1
	A	B	C
2	New	25	True
3	New	17	False
4	Used	19	True
5	New	24	True
6	New	15	False
7	Used	17	False
8	New	20	True
9	Used	14	False
10	Used	17	False
11	Used	14	False
Sheet6

Cell Formulas
Range	Formula
C2:C11	C2	=IF(AND(OR(A2="New",A2="Used"),B2>=18),"True","False")

Hi..Thanks for the reminder about my profile and am currently using Excel for Microsoft 365.

Thank you for your assistance with the formula.