If less than return specific cell

I need some help with a formula and I'm hoping you can help me. Try to follow my insane garble...

A200 is "NICE"
A201 is =C146
A202 is "LOSS"

I want L21 to return the value of whatever number is in the C146 cell.

UNLESS C146 is less than $0.00, in which case L21 should return the value in cell A202

If C146 is more than $2000, L21 should return the value of A200
******************************
So.......

If C146 is $0.00 to $1999.99, L21 returns the value of C146
If C146 is less than $0.00, L21 returns the value of A202
If C146 is $2000.00 or more, L21 returns the value of A200
******************************

Can anyone help? Thanks.

Rob

Re: If less than return specific cell

Quote from Brister

Here you go Rob. Tested it and works :

Code

=IF(AND(C146>=0,C146<=1999.99),C146,IF(C146<0,A202,IF(C146>1999.99,A200,"")))

Works perfectly! Thanks a bunch!