Cell info

[srcurrie]

How can I get cells to automatically enter a number if another is chosen.
Example
I have 3 parts needed for a project
I type in 1 in quantity of cell and other 2 cells auto. fill in with 1

 

[Von Pookie]

Assuming that that A1 is the cell you are entering into, enter the following into the cells you wish to react:

=IF(A1=1,1,"")

Hope this helps.

 

[dantb]

If all that is neaded is for the number that is typed in to be in the other cells, copy the cell where you entered the data and paste a link to cells where you would like the same number to show up in.