How do I do an if/then formula

  • Thread starter Thread starter mrsjcd3
  • Start date Start date
M

mrsjcd3

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")
 
Why should it be simple?

A blank cell cannot have an "X" or it would not be blank<g>

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
 
Back
Top