If Statement Question

[Joe]

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

 

[Don Guillett]

Look in the help index for AND to find your answer.

 

[RonaldoOneNil]

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

 

[Teethless mama]

=CHOOSE((D3<=M3)*(C3>=M3)+1,"NO EXECUTION",M3)

 

[BIG D]

Look in the help index for AND to find your answer.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software








- Show quoted text -

TRY THIS.

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