Cell info

srcurrie · Mar 21st, 2002, 09:33 AM

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 · Mar 21st, 2002, 10:15 AM

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 · Mar 21st, 2002, 10:15 AM

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.

Mar 21st, 2002, 10:15 AM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	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. __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 09:33 AM	#1
srcurrie New Member Join Date: Mar 2002 Posts: 18	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

Mar 21st, 2002, 10:15 AM	#3
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	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.