Excel formula

[Guest]

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

 

[Roger Govier]

Hi

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

 

[Guest]

Is there a way to have a number divided evenly by 6 and the output put into 6
columns?

 

[Guest]

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]

Hi

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