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")))