Excel formula
 

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

Excel formula
 

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

Excel formula
 

Is there a way to have a number divided evenly by 6 and the output put 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

Excel formula
 

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

Excel formula
 

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