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?

[Webinar] Streamline your web hosting managementRegister Today

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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
All Courses

From novice to tech pro — start learning today.