Ifs statement

[DonM9049mentions]

Seeking assistance with one formula in cell b1 that would display the following text based on formula below. I believe it would be a nested formula, however, answer shows as "NA"  

if a1<23000,"Normal Deferral"

if a1 >23000 <=30500, "Age 50 Catch-up"

if a1 >30,500, "Pre-Retirement Catch-up"

Appreciate any guidance

[#2]

@DonM9049mentions   try this:

=IFS(A1<23000, "Normal Deferral", AND(A1>=23000,A1<=30500), "Age 50 Catch-up",A1 >30500, "Pre-Retirement Catch-up")

Note in first AND statement you have to make it >= 2300 otherwise the number 23000 will give you an N/A

[#3]

@matt_1970 

Excellent. Appreciate your prompt reply. Sometimes the answer is right in front of you but you just don't see it!