@INDIRECT with IFERROR and IF statement - formula problem

[muad'ebe]

I have a cell with the formula =IFERROR(@INDIRECT("3!$M$6"),0) which works fine.

I would like to replace "3!$M$6" with an IF statement IF('3'!$M$6=5,$M$3,'3'!$M$6)

Everything I've tried has not worked.

The formula refers to tabs that are not yet there, but can be added if necessary. If the added tab cell M6=5, then I need the formula to read cell M3 of the current page. If cell M6 of the added page equals a number other than 5, it should enter the number on the added page in cell M6.

Thanks for your help.

 

[offthelip]

try this:

IF('3'!$M$6=5,Indirect($M$3),Indirect('3'!$M$6))