Basically, I want a way of making one cell equal something only when another cell is a specific value.
For example, if I entered X into B7 I would want it so D7, F7, H7, J7 and R7 would also become X.
It's a distance spreadsheet for highway accidents, every column representing 100 metres. If an accident occurs at one point, I need a marker 200m, 400m, 600m, 800m and 1 mile away.
Apologise for poor wording.
Hi,
Please read the rules on posting and amend your heading to your question to something more meaningful
To answer your question, put this in D7 then copy it to the other cells
=IF($B$7="X","X","")
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
or just... =$B$7
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks