IF and LEFT

[Lauren3077]

I am trying to write a function for IF the date in column G2 starts with 1, it should put the letter N in the cell. If the date starts with 2, it should be B. I guess it gets tricky when the months get up to 10 and the letter should be T. I have found some formulas that show how to use Left and the month, but they will only produce a numeric value. I need it to be a specific letter.

 

[Fluff]

One option would be like

=CHOOSE(MONTH(G2),"N","B","A","C","X","L")

or you could create a lookup table with the month number & letter & then use xlookup

 

[bbotzong]

Seems to me you could use the CHOOSE function. If I'm reading your question right, you want Jan = N, Feb = B, Oct Nov and Dec = T. What about the other values, like Mar-Sept? Blank? Something else?

Try this. In the cell you want the letter, enter =CHOOSE(month(G2),"N","B","x","x","x","x","x","x","x","T","T","T")

The MONTH function will return a number from 1 to 12. That number will be used by the CHOOSE function to display the nth entry in the list. The first entry for Jan, the second for Feb, the 10th, 11th, and 12th for Oct-Dec. You can replace the 'x' with whatever letters (or blank) you want for Mar-Sep.

Hope this help.

Bill B.

 

[jtakw]

Hi,

Here's just another way if I understand correctly:

Book3.xlsx
	A	B	C	D
1	1/15/2021		n	N
2	2/15/2021		b	B
3	3/15/2021		r	R
4	4/15/2021		r	R
5	5/15/2021		y	Y
6	6/15/2021		n	N
7	7/15/2021		l	L
8	8/15/2021		g	G
9	9/15/2021		p	P
10	10/15/2021		t	T
11	11/15/2021		v	V
12	12/15/2021		c	C
Sheet917

Cell Formulas
Range	Formula
C1:C12	C1	=RIGHT(TEXT(A1,"mmm"))
D1:D12	D1	=UPPER(RIGHT(TEXT(A1,"mmm")))

 

[Lauren3077]

Thanks so much. That worked on the first try (which never happens to me)!

 

[Fluff]

Glad we could help & thanks for the feedback.