=IF(A950,"",A9*2) This places an empty space in the
cell and is treated as text

You can enter a formula directly into sheet 2 and
reference another sheet like this.

=IF(Sheet1!A950,0,Sheet1!A9*2) This places a zero in the
cell and is a number. If you do not want to see the zero
choose Tools, Option, View Tab and un check the Zero check
box

Rgs
Peter

-----Original Message-----
Help,

Pretty new to functions in excel. Here is the delimma, I
have an
if-then statement in a cell, when the value is false i
want the cell
that i am in to display nothing however i want it to
place a value in
another worksheet. Ultimately I would like to have it run
a macro or
some other code, but I would imagine that at the present
time, that
may be a little advanced for me.

Thanks for your help,

Dontwanna
.