Thread: If Statement Question
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
  
Posts: 117
Default If Statement Question
=IF(AND(D3<=M3,C3=M3),M3,"NO EXECUTION")

"Joe" wrote:

=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....
Reply With QuoteReply With Quote