Hi Mark,

I am trying to end up with the formula =040208!A1+C4 not just with the
string 040208!A1+C4 hence the use of INDIRECT.

Thank you

Eric



"NoodNutt" wrote in message
...
G'day Eric

I tried this

=IF(A1="040208",(A1 & "!A1+C4"),0)

It returned

040208!A1+C4


I had to change A1 to a Text for it to work though, as I got a Ref# error
when it was General

HTH
Mark.