Question description:
This user has given permission to use the problem statement for this
blog.
Hi
I am trying to write a formula that says
If cell A has a date then use that date, if cell A has “not req†then use cell C.
Solved by A. S. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
18/10/2017 - 07:33
Welcome, Thanks for choosing Got It Pro-Excel
How may I help you today?
Excelchat Expert
18/10/2017 - 07:33
Do you want to check if cell A has date or not req ?
Excelchat Expert
18/10/2017 - 07:34
or if there is no date and nothing there ?
User
18/10/2017 - 07:35
I want to say to use cell a if it has a date but if the words “not req” are in cell a then I want to use cell c
Excelchat Expert
18/10/2017 - 07:36
so if the cell is blank ?
User
18/10/2017 - 07:37
So right now I am trying to calculate a start date based on two different cells of data
User
18/10/2017 - 07:38
so I want to say, start on this date if cell a has a date; but if cell a has the words not req then I want to start on the date shown in cell c
Excelchat Expert
18/10/2017 - 07:40
so now I am checking for not req
User
18/10/2017 - 07:40
yea
Excelchat Expert
18/10/2017 - 07:43
so now i will check for both is that ok?
Excelchat Expert
18/10/2017 - 07:44
so if the cell was blank do you want something to happened ?
User
18/10/2017 - 07:44
Ok
User
18/10/2017 - 07:44
No the cell will not be blank
User
18/10/2017 - 07:44
either the cell will have a date or it will have “not req”
Excelchat Expert
18/10/2017 - 07:45
the best practice is to check for not req
User
18/10/2017 - 07:45
ok
Excelchat Expert
18/10/2017 - 07:45
it will be better ok
User
18/10/2017 - 07:45
ok
Excelchat Expert
18/10/2017 - 07:45
you can use the below formula for that
Excelchat Expert
18/10/2017 - 07:45
=if(A1="not req",C1,A1)
Excelchat Expert
18/10/2017 - 07:46
or if you want to check for the date itself use the below formula
Excelchat Expert
18/10/2017 - 07:46
=if(ISERR(DATEVALUE(A1)),C1,A1)
Excelchat Expert
18/10/2017 - 07:47
is that clear ?
User
18/10/2017 - 07:48
it is thank you
Excelchat Expert
18/10/2017 - 07:48
we still have 5 min if you need anything else ?
Excelchat Expert
18/10/2017 - 07:49
Thanks for using Got It Pro-Excel
Please give your kind feedback for our service
Have a good day ahead
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.