J
janthony
Thanks for your help on my first issue. Here's a second one, similar t
my first question.
[image: http://img66.photobucket.com/albums/v200/civilant/IF-THEN.jpg
As you can see in the attached foto, Column N and Column P are bot
date fields that have been converted into numbers. Here are my specifi
needs:
If a date exists in Column N, but not in Column P, I need the "if-the
statement" Column to output "S".
If a date exists in Column P, but not in Column N, I need the "if-the
statement" Column to output "W"
If there is no date in Column N nor Column P (both empty), I need th
"if-then statement" Column to output "A".
I hope the attached image helps whoever is reading this. If you coul
give me the proper syntax I would be very greatful.
Thanks!
-janthon
my first question.
[image: http://img66.photobucket.com/albums/v200/civilant/IF-THEN.jpg
As you can see in the attached foto, Column N and Column P are bot
date fields that have been converted into numbers. Here are my specifi
needs:
If a date exists in Column N, but not in Column P, I need the "if-the
statement" Column to output "S".
If a date exists in Column P, but not in Column N, I need the "if-the
statement" Column to output "W"
If there is no date in Column N nor Column P (both empty), I need th
"if-then statement" Column to output "A".
I hope the attached image helps whoever is reading this. If you coul
give me the proper syntax I would be very greatful.
Thanks!
-janthon