Show Blank in date formulas

[bamaisgreat]

Im not if fixing one of these formulas will fix the others but In cell J3 i have formula =I3+1825, I3 is a date. In K3 i have =J3-TODAY() and L3 I have =IF(K3<0,"EXPIRED",IF(K3<30,"EXPIRING SOON","IN DATE")). When I copy these down and I have blank rows I need them to just be empty.

 

[bamaisgreat]

I switched them around and it says I have to many arguments.

=IF(C3="","",IF(C3<0,"EXPIRED",IF(C3<30,"WITHIN 30 DAYS","IN DATE",IF(C3<365,"WITHIN 1 YEAR"))))

 

[Joe4]

You only move the condition and TRUE clauses. Leave the FALSE clause where it is, because that is only returned if NONE of your conditions are met:

[COLOR=#333333]=IF(C3="","",IF(C3<0,"EXPIRED",IF([/COLOR][COLOR=#ff0000]C3<30,"WITHIN 30 DAYS"[/COLOR][COLOR=#333333],IF([/COLOR][COLOR=#ff0000]C3<365,"WITHIN 1 YEAR"[/COLOR][COLOR=#333333],"IN DATE"))))
[/COLOR]