Hi
I been working on a series of problems to create a speadsheet to caculate the effect of numerous different weight placed in different positions in relation to a movable fulcrum.
I'm nearly there. I can calculate the permutations and the final effect but I want to add the balance point to the equation.
If i use ="="&b2&"*3 it returns =B2*3 ("B2 being the cell content not the address). I want the returned data to be the result of the function ie if B2 was 6 then return "18".
Can it do this???
cheers
nobby

Hi,

May be you are looking for :
=CELL("contents",B2)

HTH
Cheers
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=532729

You could try

=CELL("Contents",B2)*3

Martin

http://homepage.ntlworld.com/martin.rice1/


--
mrice
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532729

isnt it just =b2*3
--
paul

remove nospam for email addy!



"nobbyknownowt" wrote:


Hi
I been working on a series of problems to create a speadsheet to
caculate the effect of numerous different weight placed in different
positions in relation to a movable fulcrum.
I'm nearly there. I can calculate the permutations and the final
effect but I want to add the balance point to the equation.
If i use ="="&b2&"*3 it returns =B2*3 ("B2 being the cell content not
the address). I want the returned data to be the result of the function
ie if B2 was 6 then return "18".
Can it do this???
cheers
nobby


--
nobbyknownowt

Brilliant
thank you all
cheers
nobby