ExcelBanter - View Single Post

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