Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IF Statement (2000/2003)

    The 3 formulas I have below work, they check the value of R16 and display the proper message when the results are true. I need all these formulas nested together into one formula so that I can place it in one cell, I can't get it to work. Can anyone help?

    =IF(R16<=110,"Low Risk","")
    =IF(AND(R16>111,R16<210),"Moderate Risk","")
    =IF(R16>=211,"High Risk","")

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: IF Statement (2000/2003)

    You can use:
    <code>=IF(R16<=110,"Low Risk",IF(R16>210,"High Risk","Moderate Risk"))</code>
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF Statement (2000/2003)

    Thats perfect, can never figure out where the "" go or the other If' statements. thanks a bunch. <img src=/S/bouncenburn.gif border=0 alt=bouncenburn width=31 height=31>

Posting Permissions

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