Results 1 to 2 of 2

Thread: IF

  1. #1

    IF



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have tried using the following IF statement and the "OK" and "High" work, but the "V,High" is just returning a "High" result, is there something wrong that I cannot see? =IF(B2<130,"OK",IF(B2>130,"High",IF(B2>140,"V.High")))

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    The IF statement stops at the point that it returns a TRUE, so you need to switch the last conditions...

    =IF(B2<130,"OK",IF(B2>140,"V.High",IF(B2>130,"High")))


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •