Forum Discussion
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 Cell B2 there is a Paid On Date I would like for it to return "P" in Col C.
I have this incomplete formula in Col C: =IF(A2<TODAY(),"PD",IF(A2>TODAY(),"TC")). I don't know how to add the third condition. May someone help with this?
I have enclosed a reference image. Column D is an example of how I would like it to be returned please.
thank you
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.
4 Replies
That could be also
=LOOKUP(TODAY()-A2-B2, {-99000,-10000,0}, {"P","TC","PD"} )or
=SWITCH( TRUE(), $B2<>"", "P", $A2 > TODAY(), "TC", "PD")This worked brilliantly. I just don't understand it. I am assuming 99000 and 10000 are equivalent to Greater and Lesser than?
Either way it works perfectly. Thank you so kindly
cheers
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.
Thanks so much, this works perfectly.
Cheers
