Not possible, a formula can only yield the result in the same cell that
holds the formula, you can use VBA to get this done however

--
Regards,

Peo Sjoblom

(No private emails please)


"mark" wrote in message
...
how to put a formula in one cell and the result in a another cell