# 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

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,"")))``
• 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!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!