Help with IF(AND(OR

Hi,

I have the following formula:

=IF(AND([@[Received_Date(Final)]]<>””,[@[Received_Date(Final)]]<TODAY(),TRIM([@[status_name]])<>”Completed”),TODAY()+TIME(7,0,0),[@[Received_Date(Final)]])

 

Basically the formula moves a date to today’s date if the status name is not equal to “completed”

 

I want to change this to move date if not equal to “Completed” or “Cancelled”

 

Any Help appreciated!

 

Thanks,

Andrew

By: Andrew Skipsey

23 thoughts on “Help with IF(AND(OR

  1. ig

    Link exchange is nothing else but it is only placing the other person’s weblog link on your page at suitable place and other person will also do
    similar in favor of you.

  2. fleck 5600sxt reviews

    Fantastic website you have here but I was curious if
    you knew of any community forums that cover the same topics talked about here?
    I’d really like to be a part of community where I can get feedback from other
    knowledgeable individuals that share the same interest.
    If you have any suggestions, please let me know.
    Thanks a lot!

  3. Karen

    With havin so much content and articles do you ever run into any issues of plagorism
    or copyright infringement? My site has a lot of completely
    unique content I’ve either created myself or outsourced but it appears a lot of it is popping it up all
    over the web without my permission. Do you know any methods to help reduce content from being ripped off?
    I’d certainly appreciate it.

  4. Michael Strollo

    Thanks , I’ve just been searching for information about this topic for ages and yours is the best I have discovered till now. But, what about the bottom line? Are you sure about the source?

  5. sling tv

    Simply want to say your article is as amazing. The clarity for
    your put up is just spectacular and i can assume you are a professional in this subject.
    Fine along with your permission let me to snatch your feed to keep updated with forthcoming post.

    Thank you a million and please carry on the rewarding work.

  6. search engine optimization for beginners

    Admiring the time and energy you put into your website and detailed information you offer.

    It’s nice to come across a blog every once in a while that isn’t
    the same outdated rehashed material. Excellent read!

    I’ve saved your site and I’m adding your RSS feeds to my
    Google account.

Comments are closed.