Hi
Would anybody be able to add the indirect function the following formula's whcih I am using please?
=IF(New_Data!D8="R","Repo",IF(New_Data!D8="Q","Reverse repo",IF(New_Data!D8="U","Outright Sale",IF(New_Data!D8="T","Outright Purchase",""))))
&
=IF(New_Data!S8=1788,"EUROCLEAR",IF(New_Data!S8=1929,"DOMESTIC",""))
thanks
Would anybody be able to add the indirect function the following formula's whcih I am using please?
=IF(New_Data!D8="R","Repo",IF(New_Data!D8="Q","Reverse repo",IF(New_Data!D8="U","Outright Sale",IF(New_Data!D8="T","Outright Purchase",""))))
&
=IF(New_Data!S8=1788,"EUROCLEAR",IF(New_Data!S8=1929,"DOMESTIC",""))
thanks