View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default If Statement Question


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....