These formulae seemed to be viable, but when performed, I get the same 300 on
the other sheet. This is what I did:
taking the first formula you gave me, I substituted Sheet1 for my sheet's
name, in this case it being PAY. I then substituted the cell to which I
wanted to reference, minding that all cell numbers on the input sheet are the
same as the output sheet.
Once I hit ENTER, the formula shows up in the cell itself. I then go to the
PAY sheet and the formula is also there, which is a good sign...the second
sheet, named PAY AFTER DEDUCTIONS, is communicating with the PAY sheet. But
inputting 300 also gives me 300 on the DEDUCTIONS sheet. Is there something
wrong with my substitutions? Following this format, I did the same thing with
the second formula and it didn't fare any better. Please help if you can!

"Gord Dibben" wrote:

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