You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] .XLS. How to Id Values between upper and lower limits?

Chat Forum

3 Posts

4 Users

0 Reactions

53 Views

benz

Posts: 1143

Free Member

Topic starter

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 : 20/11/2018 9:32 am

rogermoore

Posts: 1142

Full Member

Conditional Formatting? IF statement?
RM.

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

Posted : 20/11/2018 9:40 am

ossify

Posts: 2304

Full Member

I would use something like this:

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

Or conditional formatting to highlight them

Posted : 20/11/2018 9:45 am

reggiegasket

Posts: 943

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 : 20/11/2018 3:32 pm