formula - table - cells

  • Thread starter Thread starter ribit
  • Start date Start date
R

ribit

hello,

bit difficult to explain... but here it goes. I have a table of value
'x' and 'y'. At the moment I must enter all these values manually in
turn into 2 cells which turn calculate 'a' and 'b' values (which I must
then type in next to the appropriate 'x' and 'y' values). Is there an
automated way of doing this (posibly using VB)? Please help...

Regards

Mat
 
Mat,

With Excel, there is always a way (almost always). But we need more
information. How about putting a simple example in your next reply...
 
hi SteveB,

I have an example to explain a bit more cleary what I meant in my las
message. The equation I use in my real problem is much more comple
(equations getting results from other 'equations results' etc...) bu
it show briefly what i am trying to do...

Is it of any help?

thanks

Regards

Ma

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56092
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What excel formula gives me the funcion (x*y%)/12 in my calculator 2
Scrabble Value calculation for Welsh words 0
Linking the Regression equation of a line to a table 1
Data exchange between macro and spreadsheet 1
Range passed to a function - trying to just move through the range 4
Lookup formula needed 1
Pivot Tables - How to display multiple items? 2
Formula based on another cell value 6

Back
Top