View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aussiedaz aussiedaz is offline
external usenet poster
 
Posts: 1
Default Simple Calculator Problem


G'day Wheelz,

I had a play in excel to try and work it out, you have a circular
reference, which you prob already knew, however what i suggest is that
you have a couple of tables. eg if variables are " blue cells " then it
works out " black cells " if a black cell has to be a variable then set
up another table so that when value is put in there then it gives you a
value for the missing info in blue cells.

Dunno if you have tried this or if it helps, other than that if you
like send me an email with a detailed explanation of what each varible
is eg " Speed ( Vc ) m/min is taht velocity in metres per minute,
excuse my dumbness. I will try and help any way as i believe every
circular reference has a work around.

Cheers Daz


--
aussiedaz
------------------------------------------------------------------------
aussiedaz's Profile: http://www.excelforum.com/member.php...o&userid=37270
View this thread: http://www.excelforum.com/showthread...hreadid=569785