Compare 2 cells for a value
 

I know what I want to do but don't know how to get it done....any help
appritated.

I need to compare 2 cells and if BOTH of those cells are empty I need a "-"
in the cell, otherwise if one or both have a value I want to perform a
calculation. I have the following but it's not working. I think I just need
to know the correct symbol to use when comparing:

=(IF(E11 AND F11 = " ","-",G10+E11-F11))

HELP?

Compare 2 cells for a value
 

Change your formula as follows:

=IF(AND(E11="",F11=""),"-",G10+E11-F11)

--
Kevin Backmann


"T" wrote:

I know what I want to do but don't know how to get it done....any help
appritated.

I need to compare 2 cells and if BOTH of those cells are empty I need a "-"
in the cell, otherwise if one or both have a value I want to perform a
calculation. I have the following but it's not working. I think I just need
to know the correct symbol to use when comparing:

=(IF(E11 AND F11 = " ","-",G10+E11-F11))

HELP?

Compare 2 cells for a value
 

Hi,

=(IF(AND(E11= " ",F11= " "),"-",G10+E11-F11)

HTH

Compare 2 cells for a value
 

Marry Me.....It worked perfectly! Thanks so much

"Kevin B" wrote:

Change your formula as follows:

=IF(AND(E11="",F11=""),"-",G10+E11-F11)

--
Kevin Backmann


"T" wrote:

I know what I want to do but don't know how to get it done....any help
appritated.

I need to compare 2 cells and if BOTH of those cells are empty I need a "-"
in the cell, otherwise if one or both have a value I want to perform a
calculation. I have the following but it's not working. I think I just need
to know the correct symbol to use when comparing:

=(IF(E11 AND F11 = " ","-",G10+E11-F11))

HELP?