In a cell on sheet2 enter this formula.

=Sheet1!A1*.85

OR =IF(Sheet1!A1="","",Sheet1!A1*.85)


Gord Dibben MS Excel MVP


On Sun, 17 Feb 2008 19:42:01 -0800, ThunderStorm Studio <ThunderStorm
wrote:

I'm trying to connect two worksheets together whereas the input into a cell
of one will influence the outcome in the cell of another.

EX: Inputting 300 in a cell of the first sheet will give me an answer in a
cell of the second sheet, less 15%.

Is this at all possible? The sheets are in the same workbook. and the value
of one must impact the second.

Many thanks for any information.

Regards,
Robert