ExcelBanter - If Statement Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If Statement Question (https://www.excelbanter.com/excel-worksheet-functions/228033-if-statement-question.html)

Joe

If Statement Question

=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

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

RonaldoOneNil

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

Teethless mama

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

BIG D

If Statement Question

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")

All times are GMT +1. The time now is 10:49 AM.