IF statements using multiple conditions

[Lbender]

[TABLE="width: 100"]
<tbody>[TR]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD]Target
[/TD]
[TD]Status (Days)
[/TD]
[TD]Actual
[/TD]
[/TR]
[TR]
[TD]3/15/2019
[/TD]
[TD]33
[/TD]
[TD]4/17/2019
[/TD]
[/TR]
[TR]
[TD]4/1/2019
[/TD]
[TD]FALSE
[/TD]
[TD]3/22/2019
[/TD]
[/TR]
[TR]
[TD]4/18/2019
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I'm trying to calculate a field using IF statements, but I have 3 or 4 separate situations that I need calculations for.
Here is the function I'm using:
=IF(G6>=E6, TODAY()-E6), IF(G6<=E6, DATEDIF(E6,G6,"d")) but can't figure out how to work

My calc cells are above
Basically I need it to calculate the Past Due #of days if the Actual is after the target,
if the actual falls before the target then count the #of days ahead of schedule
if the actual is empty then say something like "In Progress"

 

[Fluff]

Hi & welcome to MrExcel
How about
=IF(G6="","In Progress",IF(G6>=E6, TODAY()-E6, IF(G6<=E6, E6-G6)))

 

[Lbender]

Doesn't work, when my actual completion date is sooner, it's showing positive difference like it's past due (maybe day difference, not today function) . I would prefer this option to show - (negative). Then is it possible to populate the results in color?

 

[Fluff]

In that case how about
=IF(G6="","In Progress",IF(G6>=E6, TODAY()-E6, IF(G6<=E6, G6-E6)))

 

[Lbender]

That did it! Now, maybe too much, but is there a way for it to auto populate color per result? Ie- positive values= red, Neg= green, In Progress=yellow?

 

[Fluff]

Not with a normal formula, you would need to use Conditional formatting for that.

 

[Lbender]

Is there a tutorial on how to do that in conditional formatting? I've never messed with that before

 

[Fluff]

Have a look here https://www.contextures.com/xlCondFormat03.html & see how you get on.

 

[Lbender]

Thanks so much! I'll check it out