Edit result from AND formula

[sharky12345]

I have this which is evaluating cells to see if they match;

=AND(EXACT(B17,D3),EXACT(B16,B7))

Presently they produce either TRUE or FALSE - but can it be tweaked to produce either VALID or NOT VALID?

I've tried this but it produces '#VALUE!'...

=AND(EXACT(B17,D3),EXACT(B16,B7),"VALID","NOT VALID")

 

[jtakw]

You need to wrap that with an IF statement.

=IF(AND(EXACT(B17,D3),EXACT(B16,B7)),"VALID","NOT VALID")

If you need a VBA solution, I can't help.

 

[sharky12345]

Thanks!

 

[jtakw]

You're welcome.