IF Statement Trouble - Excel 2003 [Nesting? THEN?] 1

[Maillme]

Hi There,

I'm want to evaluate if a value in one field (Column K) is not equal to "closed" then perform my formula below:

=IF(E2<TODAY(),"Overdue","Not Due")

And if it is = "closed" then return "item closed" in this other cell.

I am unsure how to do this - im thinking an IF THEN ELSE type of statement, but i cant find any help on this,

many thanks,
Neil

 

[GlennUK]

Something like:

=IF(K2="Closed","Item Closed",IF(E2<TODAY(),"Overdue","Not Due"))

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Maillme]

Worked perfectly.

manythanks,
Neil