Nested IF/AND not running

[tojomojo]

I am trying to compare a date against NOW() and AND it with a statys field (Complete or In progress), depending on the result a priority field is populated.

What am I doing wrong with the statement???

=IF(((AND(NOW()<>E5,F5="Complete")), "NONE", "HIGH"), IF((AND(NOW()<E5,F5="In progress")), "NONE", "HIGH"))

Thanks!!!

 

[Special-K99]

IF condition, true value, false value

Your second formula will never be executed since the first IF will return NONE if true and HIGH if FALSE.
There's no other posssibilty so the second IF will never get executed.

The forum has displayed your post incorrectly.
Edit your post and place spaces around any < or > characters.

 

[tojomojo]

How would I rewrite it to make it do what I need from the explanation. Jst cant see how to restructure....obviously a bit new to this.....Its the ANDS that are confusing me I THINK

 

[tojomojo]

Sorry here is the code added correctly

IF((AND(NOW() <> E4,F4="Complete")), "NONE", "HIGH"), IF((AND(NOW() < E4,F4="In progress")), "NONE", "HIGH"))[CODE]

 

[Gerald Higgins]

Also, be careful using the NOW() function.
It will almost never = E4.

The NOW() function returns the current date and time.
Even if you have the result formatted to only show the date, Excel will still evaluate the result taking into account the exact time.

If you want to evaluate E4 against the current date (and I'm not sure that's what you want) try replacing NOW() with TODAY()

 

[Fluff]

Maybe
=IF(OR(AND(TODAY()<>E4,F4="Complete"),AND(TODAY()< E4,F4="In progress")),"NONE","HIGH")