IFERROR and nested ISERROR with different error messages or non at all

Hi,

I managed to combine IF and ISERROR to show the error when there is one or just nothing when there isnt.

=IF(ISERROR((ROUND(GETPIVOTDATA("YEAR 13 ";Pivot!$A$26;"USGAAP";"INCOME");-5)/1000000)*-1);"Missing INCOME";"")

My new challenge is if the formula is a bit more complicated i.e. contains and addition or division.
If I now wrap the IFERROR (making it an ISERROR) within the IFERROR then I lose the differentiation for the error
message. It all becomes one.

Do any of you have a suggestion?

=IFERROR((
(ROUND(GETPIVOTDATA("YEAR 13 ";Pivot!$A$26;"USGAAP";"REVENUE EARNED");-5) / 1000000)+
(ROUND(GETPIVOTDATA("YEAR 13";Pivot!$A$26;"USGAAP";"FEES");-5) / 1000000))*-1

;"Missing "&T(IFERROR(GETPIVOTDATA("YEAR 13";Pivot!$A$26;"USGAAP";"REVENUE EARNED");"REVENUE EARNED"))&T(IFERROR(GETPIVOTDATA("YEAR 13";Pivot!$A$26;"USGAAP";"FEES");"FEES")))

Hi,

Thanks for your reply.

This formula shows nothing ("") when there is no error:

=IF(ISERROR((ROUND(GETPIVOTDATA("YEAR 13 ";Pivot!$A$26;"USGAAP";"INCOME");-5)/1000000)*-1);"Missing INCOME";"")

This formula shows the caluclation result and a proper error message, which is great but when there is no error then
I dont want to see the calculation result but instead just nothing (as in the formula above):

=IFERROR((
(ROUND(GETPIVOTDATA("YEAR 13 ";Pivot!$A$26;"USGAAP";"REVENUE EARNED");-5) / 1000000)+
(ROUND(GETPIVOTDATA("YEAR 13";Pivot!$A$26;"USGAAP";"FEES");-5) / 1000000))*-1

;"Missing "&T(IFERROR(GETPIVOTDATA("YEAR 13";Pivot!$A$26;"USGAAP";"REVENUE EARNED");"REVENUE EARNED"))&T(IFERROR(GETPIVOTDATA("YEAR 13";Pivot!$A$26;"USGAAP";"FEES");"FEES")))