Issue with Date and Text in if formula

Closed
Reinette - Mar 4, 2016 at 03:02 AM
Computertech Posts 3569 Registration date Friday February 6, 2015 Status Moderator Last seen July 18, 2016 - Mar 4, 2016 at 04:12 AM
Hello,

I'm trying to write a function for a cell which refers to different descriptions in one column - where it only should combine some description and bring through one text if the record date is greater or equal to a specific date.

Example

Declaretion Start Date Last inv. Inventory Decl frm 18 Feb 2016
2016.02.17 2016.03.04 IMPAIRED 201503 Not Actioned
2016.02.18 PENDING DONATIO Not Actioned
2016.02.19 DECLARED Accepted
2016.05.13 REJECTED160115 Accepted


If the description in the Inventory column is "Rejected / Declared" and the date is after 2016.02.17 = the result in the Decl frm 18 Feb 2016 column should be "Accepted"
If the description in the Inventory column is anything else = the result should be "Not Actioned"
Related:

1 response

Computertech Posts 3569 Registration date Friday February 6, 2015 Status Moderator Last seen July 18, 2016 892
Mar 4, 2016 at 04:12 AM
Hello,

To provide help, regarding this formula's is not easy one, no body spent time and run the formula's on their own pc and provide help to others, but here in CCM there are some volunteers who provide help in taking time to workout with the formulas you asking for, by executing on their own pc.

Therefore during asking for help you should be polite and responsible of giving respect. Please add Hello (appreciate, grateful, etc.) in the Beginning of your query and ending it by Thank you. So that it is a big thing you did for whom you help.

Hope you understand.

Generally according to our Charter we can't answer the questions who didn't follow our politeness charter. Instead we close that topic.

Please, copy, modify and repost your message respecting the politeness charter.

For CCM politeness charter please read this article:


https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

Thanks.
0