'IF' Statement for a Concaterate Formula

  • Thread starter Thread starter addie
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'IF' Statement for a Concaterate Formula 2
SUMPRODUCT with If condition 3
Create a formula that contains a complex embedded IF statement 1
Blank Cells vs. Zero Values 2
vlookup or if statement 4
Average If Array Formula 4
IF formula string 2
Formula Now Working 7

Back
Top