name references

[Sophia]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)

Hi there, I am wanting to make a formula so that I can show equations used in calculations

Usually I do this by typing: '=A/B

However I was wondering if there is a way that you can link cells into the formula to show their value rather than their cell reference

I have tried typing '=a1/b1 but then that is exactly what shows in the cells - I would like it to come up with the actual numbers in the cells referred to.

Hope that makes sense.

Thanks a lot!

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)

Hi there, I am wanting to make a formula so that I can show equations used in
calculations

Usually I do this by typing: '=A/B

However I was wondering if there is a way that you can link cells into the
formula to show their value rather than their cell reference

I have tried typing '=a1/b1 but then that is exactly what shows in the cells -
I would like it to come up with the actual numbers in the cells referred to.

Hope that makes sense.

Thanks a lot!

You could do something like:
="="&a1&"/"&b1