Function within a cell that has a number
hmm, it works fiine in mine, are you using excel 2007?
try adding brackets and quatation signs, for example
="500"&(A1+A2)
"Té" wrote:
When I tried that it said it was a circular reference and it came back 0
"Raz" wrote:
try this:
=500&A1+A2
If you want space between two then use this
=500&" "&A1+A2
You can add as many equations or text as u like, just add &
Let me know it it worked
|