Overview Chat Bike Members News Women
Viewing 4 posts - 1 through 4 (of 4 total)
  • .XLS. How to Id Values between upper and lower limits?
  • benz
    Free Member

    I have a column titled ‘£ Average Price’.  I want to identify which of these cells are between £1,000 and £25,000.

    I honestly cannot remember how to do an If statement for this.

    HELP PLEASE!

    Thanks.

    Posted 5 years ago
    rogermoore
    Full Member

    Conditional Formatting? IF statement?
    RM.

    edit sorry: if(CELL>1000,”YES”,if(CELL<25000,”YES”,”NO”))

    Posted 5 years ago
    ossify
    Full Member

    I would use something like this:

    =IF(AND(A2 > 1000, A2 < 25000), “This one! Here!”, “”)

    Or conditional formatting to highlight them

    Posted 5 years ago
    reggiegasket
    Free Member

    Roger’s need to be altered

    if(CELL>1000,if(CELL<25000,”YES”,”NO”),”NO”)

    A variant of ossify’s

    =IF(OR(A2 < 1000, A2 > 25000),””, “This one! Here!”)

    Posted 5 years ago
Viewing 4 posts - 1 through 4 (of 4 total)

The topic ‘.XLS. How to Id Values between upper and lower limits?’ is closed to new replies.

Overview Chat Bike Members News Women