Named ranges as values of IF function

Hi All,

I am trying to set a named range to be either one of two named ranges depending on an IF condition. So I have two named ranges called Abacus12 and Abacus24. Now if Abacus24 is empty I want to assign the named range Abacus to be 'Abacus12' and if not to Abacus 24.

The formula I am trying to define named range Abacus in name manager is

=IF(ISBLANK(Abacus24),Abacus12,Abacus24)

which is giving me a #NAME? error.

Any ideas how I can make this work?

Thanks