I would like to insert this formula:
IF(AND($A4="Y",I4+(INDIRECT($C4&"!$D$11")-INDIRECT($C4&"!$E$11"))<0),"NA1")
into this formula, before the IF(INDIRECT(
=IF(AND($A4="Y",I4+(INDIRECT($C4&"!$D$11")-INDIRECT($C4&"!$E$11"))>=0),I4+(INDIRECT($C4&"!$D$11")-INDIRECT($C4&"!$E$11")),IF(INDIRECT($C4&"!A"&ROW(A$11))="G",INDIRECT($C4&"!E"&ROW(A$11)),"NA"))
but Excel tells me there are too many arguments. What can I do to make it work?
Thanks
Bookmarks