| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare 2 cells for a value
Hi,
=(IF(AND(E11= " ",F11= " "),"-",G10+E11-F11) HTH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
| Compare cells | Excel Worksheet Functions | |||
| Compare two cells from reference cells | Excel Worksheet Functions | |||
| Compare cells (advanced) | Excel Discussion (Misc queries) | |||
| Compare cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
