Simple IF Statement Q - Ditzy User

B

bleu808

All,

I am having a major blonde moment here! I am embarassed to ask this
question, but I cant get this to work :confused: Please help...

Here is what I want to happen.

working row by row, if D is blank, then A should say delete, if D has
data, then no action.

I just cant get a formula that doesnt give me a 0 in the wrong spot.
name# or a circular reference error.

Is it friday yet???

Thanks in advance for your help all ;)

Bleu
 
P

Pete

You need the following formula in column A - I've assumed your data
starts in row 2, so in A2 enter:

=IF(D2="","delete","")

Copy this formula down as many rows as you have in your data set. An
alternative which reads a bit more easily:

=IF(ISBLANK(D2),"delete","")

Hope this helps.

Pete
 
Top