• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Text & Date processing - IF...AND...OR conditions

F

Frank Bacchus

Member
Hi:

I am at a crossroad trying to figure how to complete this formula:

=IF(VALUE(RIGHT(M3,10))-VALUE(TODAY())<=$X$1,"R", IF(VALUE(RIGHT(M3,10))-VALUE(TODAY())<=$X$1+5,"Y", "G"))

In this formula, a date, in M3 is subtracted from TODAY (to get the number of days). If the number of days is greater than 10 (10 is constant in $X$1) then a "R" is placed in K3; OR If the calculated number of days is greater than 10+5 (15) then a "Y" is placed the K3 cell else a "G" is placed in K3.

Now, I want to add another criteria to this formula to evaluate if the content in D3 is "Closed" or "Transfer" I want to place a "C" in K3 and bypass the rest of the conditions.

This is my crossroad. Can you help?

frank
 
Hi..
check if this solves your problem:

=IF(OR(D3="Closed",D3="Transferred"),"C", IF(VALUE(RIGHT(M3,10))-VALUE(TODAY())<=$X$1,"R", IF(VALUE(RIGHT(M3,10))-VALUE(TODAY())<=$X$1+5,"Y", "G")))
 
You must log in or register to reply here.
Back
Top