Forum Discussion

itsMonty's avatar
itsMonty
Brass Contributor
Jun 23, 2025
Solved

Use IF formula with 3 conditions based off of 2 cells

Good day all. I am trying to write an IF function that looks into Cell A2,  which has Dates, and returns "PD" if is less than Today() or "TC" if it is greater than Today() in Col C. However if in Cel...
excel
  • mathetes's avatar
    mathetes
    Jun 23, 2025

    As a variation, you could try

    =IFS(B2<>"","P",A2<TODAY(),"PD",A2>TODAY(),"TC")

    See this reference for an explanation of the IFS function, which is far better for a situation where there are multiple possible conditions. The key to sequencing it, however, is that Excel will stop evaluating conditions with the first one that it meets. That's why I put first the reference to B2 being not blank. 

     

mathetes's avatar
mathetes
Gold Contributor
Jun 23, 2025

As a variation, you could try

=IFS(B2<>"","P",A2<TODAY(),"PD",A2>TODAY(),"TC")

See this reference for an explanation of the IFS function, which is far better for a situation where there are multiple possible conditions. The key to sequencing it, however, is that Excel will stop evaluating conditions with the first one that it meets. That's why I put first the reference to B2 being not blank. 

 

itsMonty's avatar
itsMonty
Brass Contributor
Jul 07, 2025

Thanks so much, this works perfectly.

Cheers

Resources