Help adding text to my IF formula

[erniepoe]

Hi All,

Was hoping to add a little text to the end of following formula. It is working fine, but for the false condition of the IF statement, it will just return the number of times the condition is met. So for the below example, it is returning 2, which is correct, but I was hoping to add the text phrase "tied with" to the number the formula is returning, so that when the formula returns the 'value if false' statement, it would be outputting the phase "2 tied with" to the cell.

Thanks so much for any help,
Ernie



=IF(COUNTIF(H3:H33,S4)=1,INDEX(A3:A33,MATCH(S4,D3:D33,FALSE),1),COUNTIF(H3:H33,S4))

 

[Rick Rothstein]

Hi All,

Was hoping to add a little text to the end of following formula. It is working fine, but for the false condition of the IF statement, it will just return the number of times the condition is met. So for the below example, it is returning 2, which is correct, but I was hoping to add the text phrase "tied with" to the number the formula is returning, so that when the formula returns the 'value if false' statement, it would be outputting the phase "2 tied with" to the cell.

=IF(COUNTIF(H3:H33,S4)=1,INDEX(A3:A33,MATCH(S4,D3:D33,FALSE),1),COUNTIF(H3:H33,S4))

Your question is not entirely clear, but I think you are wanting to add the text to the FALSE condition only. If so, try this...

=IF(COUNTIF(H3:H33,S4)=1,INDEX(A3:A33,MATCH(S4,D3:D33,FALSE),1),"tied with "&COUNTIF(H3:H33,S4))

 

[erniepoe]

yes Rick, thanks exactly. However, this returns the result "tied with 2" when I am looking to return "2 tied with). Do I just stick your ampersand and "tied with" quotes at the end of the formula?

 

[Rick Rothstein]

yes Rick, thanks exactly. However, this returns the result "tied with 2" when I am looking to return "2 tied with). Do I just stick your ampersand and "tied with" quotes at the end of the formula?

Yes, moving the ampersand to the front and moving the blank "spacer" character to the back, of course...

=IF(COUNTIF(H3:H33,S4)=1,INDEX(A3:A33,MATCH(S4,D3:D33,FALSE),1),COUNTIF(H3:H33,S4)&" tied with")