How can I add a text

[djarcadian]

Here's the formula in question.

=IF(INDEX(Incomplete!A:A,MATCH(A2,Incomplete!A:A,0))>0,INDEX(Incomplete!A:A,MATCH(A2,Incomplete!A:A,0),""

Let's assume it returns something like 1234 if it's TRUE.

How could I amend the result so it would return 1234-1?

I tried this
=IF(INDEX(Incomplete!A:A,MATCH(A2,Incomplete!A:A,0))>0,INDEX(Incomplete!A:A,MATCH(A2,Incomplete!A:A,0)&"-1",""

but it gave me an error.

[GC Excel]

Works for me...

But did you forget the last parenthesis?

Please Login or Register  to view this content.

[MarvinP]

Hi,

Put the "-1" with the true part of the if statement...

If(Condition,True,False)

Your true part looks like INDEX(Incomplete!A:A,MATCH(A2,Incomplete!A:A,0)

So make the above INDEX(Incomplete!A:A,MATCH(A2,Incomplete!A:A,0) & "-1"

[djarcadian]

Are you sure? I thought that's what I did.

EDIT: Here's a link https://docs.google.com/spreadsheets...it?usp=sharing

See the Yellow cells.

Hi,

Put the "-1" with the true part of the if statement...

If(Condition,True,False)

Your true part looks like INDEX(Incomplete!A:A,MATCH(A2,Incomplete!A:A,0)

So make the above INDEX(Incomplete!A:A,MATCH(A2,Incomplete!A:A,0) & "-1"

[MarvinP]

This calls for the Evaluate Icon on the Formulas Tab.

Click on the cell that you think is wrong. Go to the Formulas tab and click on the Evaluate Icon. Get out your reading glasses and magnifying glass is this dialog is small. Step through the function a few times and see why it does something different than you think it should. It normally is a wrong quote or parin somewhere in the formula.

[djarcadian]

This calls for the Evaluate Icon on the Formulas Tab.

Click on the cell that you think is wrong. Go to the Formulas tab and click on the Evaluate Icon. Get out your reading glasses and magnifying glass is this dialog is small. Step through the function a few times and see why it does something different than you think it should. It normally is a wrong quote or parin somewhere in the formula.

Thanks. Yes, just a missing bracket.

Please Login or Register  to view this content.