Thread: If Statement Question
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default If Statement Question
=CHOOSE((D3<=M3)*(C3=M3)+1,"NO EXECUTION",M3)


"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