I am a new to Excel programing. I am hoping someone can please answer
this question for me.

1) I have created a named range as below

NameRange1 =INDEX(NameRange2,COLUMN())+INDEX(NameRange3,COLUM N())

2) Next I define a formula based on a logical condition

If (A5 10,NameRange1,0)

The execution of the last statement returns
INDEX(NameRange2,COLUMN())+INDEX(NameRange3,COLUMN ())

How do I make it execute the statement (rather than simply return the
dereferenced name) so that I get the result of the addition operation
back.

INDIRECT does not seem to help either. Neither does prepending "="& to
the true and false values of the if function.

Thanks