I am a bit confused.

You have an 8 in 'Sheet!Apple'!A1

If you change that 8 to an x, you want 'Sheet!Banana'!A1 to equal 8?

I think you may have a typo in your post but............?

=IF('Sheet!Apple'!A1="x", 8,"not x") entered in 'Sheet!Banana'!A1


Gord Dibben MS Excel MVP


On Fri, 18 Jul 2008 15:29:01 -0700, Therese
wrote:

Hi
I have got several sheets in one.
In 'Sheet!Apple'!A1, I have the number 8.
I want the number 8 to appear in 'Sheet!Banana'!A1, if I f.ex. put a x on
'Sheet!Apple'!A1.
Is this possible??
Thanks
Therese