Excel formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

excel user - 26 Sep 2007 20:14 GMT

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

Reply to this Message

Roger Govier - 26 Sep 2007 20:22 GMT

Hi

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

Signature

Regards
Roger Govier

>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

Reply to this Message

excel user - 26 Sep 2007 21:09 GMT

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

> Hi
>
[quoted text clipped - 8 lines]
> >
> > Thanks

Reply to this Message

excel user - 26 Sep 2007 21:13 GMT

Is there a way to take a number divide it by 6 and then place the output of
that calculation into 6 columns?

> Hi
>
[quoted text clipped - 8 lines]
> >
> > Thanks

Reply to this Message

Roger Govier - 26 Sep 2007 22:15 GMT

Hi

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

Signature

Regards
Roger Govier

> Is there a way to take a number divide it by 6 and then place the output
> of
[quoted text clipped - 15 lines]
>> >
>> > Thanks

Reply to this Message