sharing values equally in excel

Hello All,

Suppose If I enter any numeric value in any cell, how can I distribute the values equally in the other cells.

For example, in cell A1, if I enter 150, then the values should be equally distributed among three cells B1,C1 and D1 as 50 each. If I enter 90, then it should be 30 each.

Your help is much appreciated.

Thanks
Gopala Krishna Rao

in cells B1-D1 type =A1/3