Exact function to return an string other than a Boolean value

**toony** · 01-22-2021, 08:18 AM

Hi. Just using the below formula but need it to say "Not a match".
Do I need an IF function or can I include it in the formula somehow?

=EXACT(M2:M31,N2:N31),"no"))

**Glenn Kennedy** · 01-22-2021, 08:27 AM

Maybe this:

=IF(SUMPRODUCT(--(M2:M31<>N2:N31))>0,"Not a match","")

Exact function to return an string other than a Boolean value

LinkBack

Thread Tools

Rate This Thread

Display

Exact function to return an string other than a Boolean value

Re: Exact function to return an string other than a Boolean value

Thread Information

Users Browsing this Thread

Similar Threads

(UPDATE) DEFINING exact length of string for ISTEXT within AGGREGATE function

need formula or vba to find exact string through list and find exact correct string

string and boolean in function

[SOLVED] find last occurrence of a non-exact text string in unsorted table and return next column

[SOLVED] Boolean function to return whether the PC is connected to the Internet?

Function to return boolean if activeworkbook name has specific text

Font color of exact function return in excel should be customize

Bookmarks

Bookmarks

Posting Permissions