Adding IFERROR to another IF Statement

Katie001

I am trying to add an IF ERROR statement to the formula below so that it is left blank instead of saying "#invalid data type". I'm struggling to make it work and would appreciate any help.

=IF(MONTH([Launch Date]@row) <= 3, "Q1 ", IF(MONTH([Launch Date]@row) <= 6, "Q2 ", IF(MONTH([Launch Date]@row) <= 9, "Q3 ", "Q4 "))) + YEAR([Launch Date]@row)

Thank you so much!

Paul Newcome

Try this...

=IFERROR(IF(MONTH([Launch Date]@row) <= 3, "Q1 ", IF(MONTH([Launch Date]@row) <= 6, "Q2 ", IF(MONTH([Launch Date]@row) <= 9, "Q3 ", "Q4 "))) + YEAR([Launch Date]@row), "")

Paul Newcome

Try this...

=IFERROR(IF(MONTH([Launch Date]@row) <= 3, "Q1 ", IF(MONTH([Launch Date]@row) <= 6, "Q2 ", IF(MONTH([Launch Date]@row) <= 9, "Q3 ", "Q4 "))) + YEAR([Launch Date]@row), "")

Katie001

That worked like a charm, than you so much Paul!

Paul Newcome

Happy to help. 👍️