Assigning an "N" to blank cells within a table

Rameses

Board Regular
Joined
Mar 3, 2010
Messages
137
Hi all

please may you help me with a formula to assign an "N" where a cell is blank
eg.

Column A = Grades

A1 = B
A2 = c
A3 = d
A4 =
A5 = f
A6 = G

I would like A4 to return an N

I know its an IF but I have been playing around with no joy!

many thanks

Rameses
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Rameses

Board Regular
Joined
Mar 3, 2010
Messages
137
something along the lines

=if(a1:a7=0,"N",A1:A7)

but this doesnt seem to work


??
 

jeffreybrown

Well-known Member
Joined
Jul 28, 2004
Messages
5,145
How long is your list and is this a one time event or something that will be accomplished over an over?

Do you want a formula in just A4 or where?
 

Rameses

Board Regular
Joined
Mar 3, 2010
Messages
137
Hi Jeff

its A1:A52

In the column there are a number of blank cells


many thanks

rameses
 

jeffreybrown

Well-known Member
Joined
Jul 28, 2004
Messages
5,145

ADVERTISEMENT

IMO, the best way is to use the blank cells technique...

Select the cells >> A1:A52

Press >> Ctrl + G

Select >> Special

Check >> Blanks

Type in an "N" (without the "")

Press Ctrl + Enter
 

Watch MrExcel Video

Forum statistics

Threads
1,119,113
Messages
5,576,184
Members
412,703
Latest member
sainayzawhtwe
Top