| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
try
=if(or(reference="",element=""),"",reference&eleme nt) "addie" wrote: Hi, I need an "IF" function for the concaterate formula that I'm working on below: Reference Element Consolidation 222 10000 22210000 CORRECT 10000 10000 WRONG The consolidation field can only be populated with characters if both the reference and element fields are populated. If either 'Reference' or 'Element' is missing characters, the consolidation field must be not be populated with any characters. It must simply read 'false' or 'blank'. Thanks. -- addie ------------------------------------------------------------------------ addie's Profile: http://www.excelforum.com/member.php...o&userid=25526 View this thread: http://www.excelforum.com/showthread...hreadid=390068 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Again-revealing the contents of formula | Excel Worksheet Functions | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| =IF Statement formula or conditional formatting | Excel Worksheet Functions | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
Hybrid Mode
