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!