'IF' Statement for a Concaterate Formula

[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

 

[Govind]

Hi,

Use

=IF(OR(ISBLANK(A1),ISBLANK(B1)),"",A1&B1)

where column A has reference and column B has element. copy it to the
range you need.

Govind

 

[addie]

Govind,

IT WORKED!!!!!!!!!!

Thank you so much.

All the best,

Addi