| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Linear Mode
