'IF' Statement for a Concaterate Formula

A

addie

Hi,

I need an "IF" function for the concaterate formula that I'm working o
below:

Reference Element Consolidation
222 10000 22210000 CORRECT
10000 10000 WRONG

The consolidation field can only be populated with characters if bot
the reference and element fields are populated. If either 'Reference'
or 'Element' is missing characters, the consolidation field must be no
be populated with any characters. It must simply read 'false' o
'blank'.

Thanks
 
Top