|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 05:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com