Excel help please.

[Colbaker]

Hi all,

I want to have 2 Cells in which i can enter a number and it automatically divide's the entered number in the cell 1 by 7 and divide by 4 in the second cell, Whats a good formula to use?

 

[Vonhelmet]

Put number in cell A1

A2 = A1/7
A3 = A1/4

 

[namnoc]

No that is far to simple use:

A2 = A1 * 0.14285714285714285714285714285714
A3 = A1 * 0.25