if statement in calculated columns RRS feed

  • Question

  • I have three columns

    [Event name]   [Company level event]   [Department level event]      
    Event a              5/6/2009                        
    event b              5/7/2009                            5/9/2009

    I want the department level event to be a calculated column. If [event name]=a then [department level event] = [company level event -7]
    Is this possible

    Tuesday, June 23, 2009 8:55 PM