Results 1 to 3 of 3

Thread: IF more than a certain value then True if not then false

  1. #1

    IF more than a certain value then True if not then false



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

    Hi All,

    in cell H12 i will be entering numbers 1 to 100 i want a formula for cell Q3 that will tell me if number 1 to 11 are there to be True if anything over 11 to be false! i want the answer to show up in cell Q3.


    thank you guys


    Ricky

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,491
    Articles
    0
    Excel Version
    Excel 2016
    In Q3 enter formula:

    =H12<=11


  3. #3
    thank you! perfect

Tags for this Thread

Posting Permissions

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