| 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? |
| 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) | |||
Threaded Mode
