IF formula

T

Tufail

hello,
now i am using below formula which is working, but now i want extend bit
more that is if S7 (has date) if older than today(date) then need "Timeover"
=IF(Q7="","Waiting Ship","Shipped") <-- Now using

=IF(Q7="","Waiting Ship","Shipped",IF(S7<"TODAY()","Timeover")) <-- New want

Thanks in advance.
 
B

bj

not completely sure on your priority levels but
maybe
=if(Q7="",if(S7<today(),"Timeover","Waiting ship"),"Shipped")
 
Top