Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel
Hi,
I have a column which contains dates, i want to get a result of " done" in the column next to it if any date is available , or "outstanding" if the there is no date. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel
Assuming the dates in column A, one way:
B1: =IF(A1="","outstanding","done") In article , "Mohamed" wrote: Hi, I have a column which contains dates, i want to get a result of " done" in the column next to it if any date is available , or "outstanding" if the there is no date. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel
Not clear,
Assume the result: coulm a coulm b 12-8-2004 Done 13-8-2004 Done NA not done NA not done IE : ANY DATE SHOWN IN COLUM A , SHOULD GET A RESULT WITH "DONE" & IF THERE IS NO DATE , GET A RESULT WITH "NOT DONE" THANK YOU VERY MUCH "JE McGimpsey" wrote: Assuming the dates in column A, one way: B1: =IF(A1="","outstanding","done") In article , "Mohamed" wrote: Hi, I have a column which contains dates, i want to get a result of " done" in the column next to it if any date is available , or "outstanding" if the there is no date. Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel
Dates are just numbers to excel. Maybe you can use that:
=if(isnumber(a1),"done","not done") Mohamed wrote: Not clear, Assume the result: coulm a coulm b 12-8-2004 Done 13-8-2004 Done NA not done NA not done IE : ANY DATE SHOWN IN COLUM A , SHOULD GET A RESULT WITH "DONE" & IF THERE IS NO DATE , GET A RESULT WITH "NOT DONE" THANK YOU VERY MUCH "JE McGimpsey" wrote: Assuming the dates in column A, one way: B1: =IF(A1="","outstanding","done") In article , "Mohamed" wrote: Hi, I have a column which contains dates, i want to get a result of " done" in the column next to it if any date is available , or "outstanding" if the there is no date. Thanks -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel
Thank you very much
"Dave Peterson" wrote: Dates are just numbers to excel. Maybe you can use that: =if(isnumber(a1),"done","not done") Mohamed wrote: Not clear, Assume the result: coulm a coulm b 12-8-2004 Done 13-8-2004 Done NA not done NA not done IE : ANY DATE SHOWN IN COLUM A , SHOULD GET A RESULT WITH "DONE" & IF THERE IS NO DATE , GET A RESULT WITH "NOT DONE" THANK YOU VERY MUCH "JE McGimpsey" wrote: Assuming the dates in column A, one way: B1: =IF(A1="","outstanding","done") In article , "Mohamed" wrote: Hi, I have a column which contains dates, i want to get a result of " done" in the column next to it if any date is available , or "outstanding" if the there is no date. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|