ARRAYFORMULA and IF

[Jewells0905]

I am trying to the copy the movie genre from column D if it's not empty, otherwise insert the text string "N/A" into Column E using ARRAYFORMUlA and IF. Here is the formula I'm using, which is working, however, it's producing TRUE or N/A instead of the movie title or N/A. I know this is a simple fix, but for the life of me can not get it to work.

=ARRAYFORMULA(IF(ISBLANK(D2),"N/A",ISTEXT(D2)))

Year	Length	Title	Genre	Genre2	Actor
1990	111	Tie Me Up! Tie Me Down!	Comedy	TRUE	Banderas
1991	113	High Heels	Comedy	TRUE	Bosé
1983	104	Dead Zone		N/A
1979	122	Cuba	Action	TRUE	Connery

 

[etaf]

is this in googlesheets OR excel
I dont have arrayformula in excel 365
=IF(ISBLANK(D2),"N/A",ISTEXT(D2)))
istext will give TRUE /FALSE

try
IF(ISBLANK(D2),"N/A",D2)

Book2
	A	B	C	D	E	F
1	Year	Length	Title	Genre	Genre2	Actor
2	1990	111	Tie Me Up! Tie Me Down!	Comedy	Comedy	Banderas
3	1991	113	High Heels	Comedy	Comedy	Bosé
4	1983	104	Dead Zone		N/A
5	1979	122	Cuba	Action	Action	Connery
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=IF(ISBLANK(D2),"N/A",D2)

 

[Fluff]

@Jewells0905 As you have been told before, in future please post questions for Google Sheets in the General Discussion & Other Applications section of the board.
I have moved it for you this time

 

[Jewells0905]

I got this one figured out using the below formula
=ARRAYFORMULA(IF(D2:D<>"",D2:D,"N/A"))

 

[Jewells0905]

is this in googlesheets OR excel
I dont have arrayformula in excel 365
=IF(ISBLANK(D2),"N/A",ISTEXT(D2)))
istext will give TRUE /FALSE

try
IF(ISBLANK(D2),"N/A",D2)

Book2
	A	B	C	D	E	F
1	Year	Length	Title	Genre	Genre2	Actor
2	1990	111	Tie Me Up! Tie Me Down!	Comedy	Comedy	Banderas
3	1991	113	High Heels	Comedy	Comedy	Bosé
4	1983	104	Dead Zone		N/A
5	1979	122	Cuba	Action	Action	Connery
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=IF(ISBLANK(D2),"N/A",D2)

thank you! I didn't see this until after I had posted. Both formulas work.

 

[etaf]

you are welcome