If blank then put N/A if not then list value

[dmart]

Have two columns, A and B. Trying to get column A's value into column B. I want it so that if column A has a value it lists the value in column B but its blank that it puts "N/A" down.


=IF(A<=0,A,IF(ISBLANK(A),"N/A",B)) This seems to not work

 

[Nine Zero]

Try this...in cell B1 and drag it down your list

=IF(A1="","N/A",A1)

 

[MrKowz]

Something like this?

Excel 2013/2016
	A	B
1	List	Values
2	stuff	stuff
3		N/A
4	foo	foo
5	trampoline	trampoline
6		N/A
7	burger	burger
8	carpet	carpet
9		N/A
10		N/A
11		N/A
12	table	table
Sheet6

Cell Formulas
Range	Formula
B2	=IF(A2<>"",A2,"N/A")

 

[Fluff]

In B2 put =IF(ISBLANK(A2),"N/A",A2) and fill down

 

[dmart]

Thanks Guys!