ExcelBanter - How to link cells so that if one is not answered then the other cannot be filled in

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to link cells so that if one is not answered then the other cannot be filled in (https://www.excelbanter.com/excel-worksheet-functions/48693-how-link-cells-so-if-one-not-answered-then-other-cannot-filled.html)

dips112

How to link cells so that if one is not answered then the other cannot be filled in

How to link cells so that if one is not answered then the other cannot
be filled in

--
dips112
------------------------------------------------------------------------
dips112's Profile: http://www.excelforum.com/member.php...o&userid=27825
View this thread: http://www.excelforum.com/showthread...hreadid=473321

GeorgeF

The information you gave suggests that, for example, if A1 is not being
answered and you do not want B1 to be filled, then in B1 you write:
=IF(A1=0,"","")
Does that work?
GeorgeF

--
GeorgeF
------------------------------------------------------------------------
GeorgeF's Profile: http://www.excelforum.com/member.php...o&userid=24124
View this thread: http://www.excelforum.com/showthread...hreadid=473321

All times are GMT +1. The time now is 12:15 PM.