Add additional items to existing formula

Sherry Fox

I wish to ADD the following to my existing formula:

[Reporting Period]@row="Jan", "Jan"

[Reporting Period]@row="Mar", "Mar"

[Reporting Period]@row="May", "May"

[Reporting Period]@row="Jul", "Jul"

[Reporting Period]@row="Sep", "Sep"

[Reporting Period]@row="Nov", "Nov"

Here is my current formula:

=IF(CONTAINS("-", LEFT([Reporting Period]@row, FIND(" (", [Reporting Period]@row))), RIGHT(LEFT([Reporting Period]@row, FIND(" (", [Reporting Period]@row)), 4), LEFT([Reporting Period]@row, FIND(" (", [Reporting Period]@row)))

Paul Newcome

A nested IF is actually pretty straightforward when there is already a working piece of the formula that just needs additional logic added to it.

But yes. You could use your logic and write a brand new formula as well. That would look something along the lines of

=IF(MID([Reporting Period]@row, 5, 1) = "-", RIGHT(LEFT([Reporting Period]@row, 9), 3), [Reporting Period]@row)