How do I do an if/then formula

I know this should be simple but I need help,

I need a blank cell to have "X" and a non-blank cell to have "Have"

Thanks!

Hi,
I don't quite understand your question, if you mean when A1 is blank to
enter an X in cell B1 or "Have" if A1 is not blank use

=if(A1="","X","HAVE")


"mrsjcd3" wrote:

I know this should be simple but I need help,

I need a blank cell to have "X" and a non-blank cell to have "Have"

Thanks!

Why should it be simple?

A blank cell cannot have an "X" or it would not be blankg

A cell cannot have a formula and a value.

Do you want to use formulas in helper cells to achieve this?

In B1 =IF(A1="","X","Have")

Do you want to use VBA code to achieve this without formulas?

Sub test()
For Each cell In Selection
If cell.Value = "" Then
cell.Value = "X"
Else
cell.Value = "Have"
End If
Next
End Sub


Gord Dibben MS Excel MVP


On Tue, 15 Sep 2009 10:41:01 -0700, mrsjcd3
wrote:

I know this should be simple but I need help,

I need a blank cell to have "X" and a non-blank cell to have "Have"

Thanks!

I understand now. I will probably use the VBA in this instance.
Thanks!

"Gord Dibben" wrote:

Why should it be simple?

A blank cell cannot have an "X" or it would not be blankg

A cell cannot have a formula and a value.

Do you want to use formulas in helper cells to achieve this?

In B1 =IF(A1="","X","Have")

Do you want to use VBA code to achieve this without formulas?

Sub test()
For Each cell In Selection
If cell.Value = "" Then
cell.Value = "X"
Else
cell.Value = "Have"
End If
Next
End Sub


Gord Dibben MS Excel MVP


On Tue, 15 Sep 2009 10:41:01 -0700, mrsjcd3
wrote:

I know this should be simple but I need help,

I need a blank cell to have "X" and a non-blank cell to have "Have"

Thanks!