| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula
not completely sure on your priority levels but
maybe =if(Q7="",if(S7<today(),"Timeover","Waiting ship"),"Shipped") "Tufail" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF formula
thank you very much and this is what i was looking.
"bj" wrote: not completely sure on your priority levels but maybe =if(Q7="",if(S7<today(),"Timeover","Waiting ship"),"Shipped") "Tufail" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
