Thread: Variable within a formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NoodNutt NoodNutt is offline
external usenet poster
  
Posts: 221
Default Variable within a formula
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.


Reply With QuoteReply With Quote