Hi, I need to divide/distribute one cell value across multiple cells equally; for example
Cell A1 has a value of "80". I need to distribute this "80" from B1 to B8 so each B1 to B8 cells has a value of "10" without using formula =A1/8.
Is there a different formula/way for this?
Thanks a bunch!