What if statement

[angela.wheat]

Hi, I need to write a what if statement for this:

If $1.00 to $34999.99 = CM
If $35,000.00 to $100,000.00 = AA
If over $100,000 = FCCNN

Please help

[Jonmo1]

Try

=IFERROR(LOOKUP(A1,{1,35000,100001},{"CM","AA","FCCN"}),"N/A")

[bhenlee]

Try:

=IF(A1>100000,"FCCNN",IF(A1>34999.99,"AA","CM"))