On Apr 17, 10:23*am, "Don Guillett" wrote:
Look in the help index for AND to find your answer.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Joe" wrote in message

...



=IF(D3<=M3 and C3=M3,M3,"NO EXECUTION")

The above is yielding #NAME?

What is the proper syntax?

Everytime I have a need for this evaluation I stump myself on this
question.
Thanks....- Hide quoted text -

- Show quoted text -

TRY THIS.

=IF(AND(D3<=M3,C3=M6),M3,"NO EXECUTION")