Excel formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi

Supposing your formula is in cell B6 and you also want the result in cell
C12.
In C12 enter =B6
 
Is there a way to take a number divide it by 6 and then place the output of
that calculation into 6 columns?
 
Back
Top