Using Multiple IF Functions in same expression

[thisishailstorm]

Hello, I am trying to change the values in my Status column to either Overdue, On Track, or Blank.

These will reference my Due Date column.
I have figured out how to have my cell = Overdue or On Track, but am having difficulty adding an additional layer to the formula.
Currently, I have Overdue if due date is < than today, On Track otherwise, however I would like the cell to be Blank if Due Date cell is empty.

This is what I have so far:
=IF(G12<today(),"Overdue","On Track")

How do I add the additional condition in my formula?

Thanks!

 

[jtakw]

Hi,

Just add another IF test for G12 being Blank:

=IF(G12="","",IF(G12< TODAY(),"Overdue","On Track"))

 

[thisishailstorm]

Awesome - thanks!!

 

[jtakw]

You're welcome, welcome to the forum.

 

[thisishailstorm]

Hey, I would like to add an additional item to this formula.
I want the cell to say complete if the date cell is changed to Complete. what i've done below doesn't work. Any feedback? Thank you!!
=IF(G15="","",IF(G15< TODAY(),"Overdue","On Track",IF(G15="Complete","Complete"))

 

[thisishailstorm]

EDIT ^^^^
I'd prefer to have the cell say Complete when a checkbox is ticked in I15.
So the formula will state =IF(G12="","",IF(G12< TODAY(),"Overdue","On Track")) as well as if I15 checkbox=true, then "Complete".