Help needed with If statements

[ginstermanuk]

Hi all,
I'd rather do this without writing a macro if possible, i will have a list of values (one per day), these values need to be categorised as the following, Low, Low to high, high and high to low.
Low is below 50
High is above 100
Low to high is higher than the previous day but higher than 50 and less than 100
High to Low is lower than the previous day but higher than 50 and less than 100

so if i have three columns, a date column, a values column, and the final column which uses if statements(?) to show "Low","Low to High", "High", "High to Low"

What do i need to do for the if statement to work, if indeed an IF statement is the right way to do it

Thanks in advance

 

[Eric W]

Try:

Book1
	A	B	C
1	Date	Value	Category
2		48	Low
3		55	Low to high
4		67	Low to high
5		101	High
6		102	High
7		75	High to low
8		14	Low
9
Sheet11

Cell Formulas
Range	Formula
C2:C8	C2	=IF(B2<50,"Low",IF(B2>100,"High",IF(B2>N(B1),"Low to high",IF(B2<N(B1),"High to low"))))

 

[Snakehips]

I wonder if your definitions are meant to effectively exclude the values 50 and 100?
If not then I was just coming up with similar to Eric.

MRXLMAY21.xlsm
	A	B	C
1	Date	Value	Rating
2	01/07/2021	100	High
3	02/07/2021	42	Low
4	03/07/2021	56	Low To High
5	04/07/2021	67	Low To High
6	05/07/2021	54	High To Low
7	06/07/2021	49	Low
8	07/07/2021	52	Low To High
9	08/07/2021	88	Low To High
10	09/07/2021	101	High
11	10/07/2021	100	High
12	11/07/2021	99	High To Low
Uplift

Cell Formulas
Range	Formula
C2:C12	C2	=IF(B2="","",IF(B2<=50,"Low",IF(B2>=100,"High",IF(B2>B1,"Low To High","High To Low"))))

Hope that helps.

 

[ginstermanuk]

Thanks both, much appreciated