Excel CountIf Formatting Query Adding String to 'Value if False' Parameter

Heyas,

I have following excel formula:

=IF(COUNTIF($C30:$C7277,Sheet1!D2) =0,"No Match ", Sheet1!D2)

I would like to add a string to the parameter 'value if false' eg. =IF(COUNTIF($C30:$C7277,Sheet1!D2) =0,"No Match ", "Match" Sheet1!D2) This gives me a formatting error.

How would I go about correcting this?

Thank you.
ZackGeneral IT Goto GuyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Try it like this....

=IF(COUNTIF($C30:$C7277,Sheet1!D2),"Match "& Sheet1!D2,"No Match")

Open in new window

0
 
xtermieCommented:
Hi
You don't need th last parameter...try
=IF(COUNTIF($C30:$C7277,Sheet1!D2) =0,"No Match ", "Match")
0
 
ZackGeneral IT Goto GuyAuthor Commented:
Hi xtermie,

The idea is for me to show the word 'Match' and the matching value alongside it.

Thank you.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
ZackGeneral IT Goto GuyAuthor Commented:
Thank you that fixed it.
0
 
xtermieCommented:
a sorry did not understand that :)
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome. Glad to help.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
@xtermie
It happens with all of us. sometimes we misunderstood a simple ask. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.