A formula can only affect the cell that it is in - you can't "push"
data to another cell. Perhaps if you could give us some more detail of
what you want to do, we might be able to help you further.

Pete

On Jun 22, 2:28 pm, Neall wrote:
I am creating a bunch of if statements but want the results to return to
cells on a different worksheet

Thanks in advance
--
Neall