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