Combine 2 functions

[afterthoughts]

Is there any way to have these 2 statement combine into one statement or put into one cell?
=IF(AND(G4<>"",G4<=TODAY(),I4>0),"Pass due by "&(TODAY()-G4)&" Days","")
=IF(AND(G4<>"",G4>=TODAY(),I4<>0),"Due In "&(TODAY()-G4)&" Days","")
or is there a easy way to do this ?

[Glenn Kennedy]

Hi there. This should do what you want.

=IF(AND(G4<>"",G4<=TODAY(),I4>0),"Pass due by "&(TODAY()-G4)&" Days",IF(AND(G4<>"",G4>=TODAY(),I4<>0),"Due In "&(TODAY()-G4)&" Days",""))

[afterthoughts]

Hi there. This should do what you want.

=IF(AND(G4<>"",G4<=TODAY(),I4>0),"Pass due by "&(TODAY()-G4)&" Days",IF(AND(G4<>"",G4>=TODAY(),I4<>0),"Due In "&(TODAY()-G4)&" Days",""))

Thanks so much it worked perfect

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.