Display a text when a certain cell is answer

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

How can I display a cell text when a certain cell is the answer? For example, when cell A2 is the answer, then the text in cell A1 is displayed; when cell B2 is the answer, then the text in cell B1 is displayed.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Not know what your meant by "answer, hope this helps

=IF(IF(a1="", "", IF(A1=5, "Yes", "no"))

this formula is saying

if A1 = blank then show nothing
If a1 is 5 then show YES
if a1 not equal to 5 then show "No"