Hi

Supposing your formula is in cell B6 and you also want the result in cell
C12.
In C12 enter =B6

--
Regards
Roger Govier



"excel user" wrote in message
...
I have a formula and I want the answer to that formula to be displayed in
more than one cell. I know that I could just copy the value into the other
cells but I wanted to know if there is a way to do it automatically, maybe
within the orginal formula.

Thanks