Hi

With the value to be divided in A1, enter in A2
=$A$1/6
Copy down through A3:A7

--
Regards
Roger Govier



"excel user" wrote in message
...
Is there a way to take a number divide it by 6 and then place the output
of
that calculation into 6 columns?

"Roger Govier" wrote:

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