0

I have been researching this and I have found several different iterations of the formula, but I just can't get mine to work. I am trying to create an if/and formula in a calculated field. I am trying to show data based on three criteria.

  1. If the create date is greater than month 2 and less than month 8 then OCTOBER 1
  2. If the account change type is Immediate: Error or Business Case then MONTH([CreateDate])+1 and 1.
  3. Otherwise MARCH 1

This is the formula I have:

=IF(AND([Created]>2,[Created]<8),"OCTOBER 1",IF([Account Change Type]="Immediate:  Error or Business Case"),"ASAP","MARCH 1"))

These are the forums I have looked at and still can't get it:

Stack Overflow

Social TechNet

StackExchange

Community
  • 1
  • 1
Tangi12
  • 1
  • 3
  • I just realized the formula provided "ASAP" instead of the MONTH([CreateDate])+1 and day 1 result. Either will work for me. -- Thanks! – Tangi12 Mar 31 '15 at 20:58

1 Answers1

0

The simple answer that pops to mind is that you have an extra parentheses at the end of that formula. If you want to test these formula syntax wise, just put them in Excel.

If you're having another issue beyond that, can you provide an error or specific symptom of some sort?

Graham
  • 336
  • 1
  • 13
  • Thank you! That worked! I just pasted the formula into Excel and replaced column references with cell references and found the error there. – Tangi12 Apr 01 '15 at 12:44
  • Excellent. Feel free to check this one as the answer. :) – Graham Apr 01 '15 at 15:56