There are three if statements I'd like to combine to automate the following actions.
If the column labeled "Package" is one of three values, it needs to add a different amount of days to the "JIRA Creation Date":
- If "Package" is "Standard" it needs to add 21 days
- If "Package" is "Advanced" it needs to add 28 days
- If "Package" is "Enterprise" it needs to add 42 days
If "Package" is none of these values, the cell that the value is being calculated into can remain blank.
"Package" is formatted as general, "JIRA Creation Date" as a date, and the column the formula is in is a date
The following statement works, calculating the correct value, but has an error "This cell is inconsistent with the column formula"
=IF([@Package]="Standard", [@[JIRA Creation Date]]+21, IF([@Package]="Advanced", [@[JIRA Creation Date]]+28, IF([@Package]="Enterprise", [@[JIRA Creation Date]]+42, "")))
Why is it doing this?
Screen Shot 2013-01-21 at 2.50.26 PM.png
Bookmarks