Multiple IF formulas

[pushruk]

Hi there...I am trying to build a formula where it checks the start and end date of a contract and says if the contract is still effective or expired. Eg below

=IF(TODAY()>S703,"Expired","Effective")

However i need to bring in a new function to this...as some of the contracts run into indefinite time periods...so they will not have an end date...

How can i modify this formula to reflect "indefinite" in addition to the "expired" and "effective" i already have (in the IF formula).

Currently the "end date" column is blank for all indefinite contracts.

Is it a matter of a simple if formula...or is there an excel icon or something which i have to insert into the "end date " column to get this done.

Thanks

[brokenbiscuits]

=if(S702="","Indefinite",IF(TODAY()>S703,"Expired","Effective"))

[Fotis1991]

=IF(TODAY()>S703,"Expired","Effective") indefinite

Try this:

=IF(TODAY()>S703,"Expired",IF((TODAY()<=S703,"Effective","Indefinate")

[TMS]

=IF(S703="", "Indefinite", IF(TODAY()>S703,"Expired","Effective"))


Regards

[pushruk]

Thanks guys. This really helps