IF function is returning FALSE

[Cloud67]

Hello,

I am trying to get today's date in a column if it meet two conditions. if one column say "Completed" and other column is "not empty" means if the date is already there. I am using following formula.

=IF([@[End Date]]="",IF([@Progress]="Completed",[@[End Date]]=TODAY(),"IT is not Completed"),"End Date is not Empty")

I am getting following result:

1- When End Date is empty: "IT is not Completed"
2- When End Date is Empty and Progress has Completed: "FALSE"
3- When End Date is not Empty: "End Date is not Empty"

So it is giving expecting result except when it meet the both condition like number 2. I have tried to change Today() to simple text like "TT" but still it is giving same issue.

I would greatly appreciate your help.

Thanks,

 

[Joe4]

I am trying to get today's date in a column if it meet two conditions.

I think you are missing the AND operator.
If you are checking for more than one condition, you need to use the AND function if all conditions must be true, or the OR function if any one of the conditions must be true.

The structure should look like:
=IF(AND(condition 1, condition 2),what to return if both true,what to return otherwise)

 

[Cloud67]

I think you are missing the AND operator.
If you are checking for more than one condition, you need to use the AND function if all conditions must be true, or the OR function if any one of the conditions must be true.

The structure should look like:
=IF(AND(condition 1, condition 2),what to return if both true,what to return otherwise)

Thanks for your reply, It is still doing the same thing means when both conditions are met, it is giving "FALSE".

=IF(AND([@[End Date]]="",[@Progress]="Completed"), [@[End Date]]=TODAY(),"Conditions are not met")

 

[Joe4]

You have this in the "what to return if both true" argument:

[@[End Date]]=TODAY()

That is a boolean argument (a comparison of two values). So it will simply return TRUE or FALSE.
If you want to return a specific value, put the value you want in that argument, not a boolean comparison.
If you want it to return the current date, just put:

TODAY()

in that argument.

Note that in Excel formulas, you do NOT tell it what cell to return the value to. That is not how formulas work.
Excel formulas can only return values to the cell that the formula is located in.
So you need to put the formula in the cell where you want the returned result.

 

[Cloud67]

You have this in the "what to return if both true" argument:

[@[End Date]]=TODAY()

That is a boolean argument (a comparison of two values). So it will simply return TRUE or FALSE.
If you want to return a specific value, put the value you want in that argument, not a boolean comparison.
If you want it to return the current date, just put:

TODAY()

in that argument.

Note that in Excel formulas, you do NOT tell it what cell to return the value to. That is not how formulas work.
Excel formulas can only return values to the cell that the formula is located in.
So you need to put the formula in the cell where you want the returned result.

 

[Cloud67]

Thanks for the explanation. Is it possible through function to enter todays date when one column say "Completed" but do not update it later like Today() function. I cannot use macro as I cannot use xlsm file.

 

[Joe4]

So, you want to do something like a "DateStamp" (capture the current date) without using VBA?
That gets a little tricky.

I always use VBA myself for something like that, but there are ways of doing it without VBA that are explained here: How to Insert Excel Timestamp When Cell Changes Without VBA (3 Ways)