IF Formula Question

[yooheest]

Hi, Ive been for this report that i cant figure how to work.


Can someone help me with a formula that will display expired remarks.
For example i have
=IF(k5>NOW,k5<<now,if(m5>NOW,IF(m5><now,if(o5>NOW,m5<NOW,IF(o5><now,if(s5>NOW,o5<NOW,IF(s5>NOW,s5<NOW))<now))

k5, m5, o5, s5 are the columns that contains date of expiration, i want the expiration dates computed and displayed on another column if they are expired or not with remarks as Expired certificate. Is this possible??

Looking forward for any assistance, thank you..</now))
</now,if(s5></now,if(o5></now,if(m5>

 

[yooheest]

Thanks for this sir Scott..