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