locked
Calculated column syntax error RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi everyone,

    I'm attempting to fill in a formula for a calculated column.

    =IF(AND([Exec], Status<>Completed, Status<>Cancelled), Title, "")

    Essentially, I need a formula that says "If Exec is equal to yes and Status does not equal completed and status does not equal canceled, if true return Title, if false return "".

    Any ideas?

    Thanks for any assistance you can provide,

    Karen

    Tuesday, May 1, 2012 9:32 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Karen,

    Please use the below syntax , I hope this will help you out with the above mentioned requirement.

    =IF(AND(Exec,Status<>"Completed",Status<>"Cancelled"),Title,"")

    Regards,

    Sachwani

    • Marked as answer by kb0722 Wednesday, May 2, 2012 9:54 PM
    Wednesday, May 2, 2012 2:28 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Karen,

    Please use the below syntax , I hope this will help you out with the above mentioned requirement.

    =IF(AND(Exec,Status<>"Completed",Status<>"Cancelled"),Title,"")

    Regards,

    Sachwani

    • Marked as answer by kb0722 Wednesday, May 2, 2012 9:54 PM
    Wednesday, May 2, 2012 2:28 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Worked like a charm!
    Wednesday, May 2, 2012 9:54 PM