Comparing 2 Columns and returning an answer

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I'm trying to figure out a formula. If Column D = X then I want to return the value in Column B from the same row. Does that make sense? I would really appreciate any help.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
looks like you are looking for IF statement

=IF(D1="X", B1, "")

this says if D1 is x, then show me B1 value. If d1 is not x, then show me ""

You can have upto 7 nested if and you can use AND /OR with IF

example
=IF(AND(cond1, cond2), true, false)
=IF(AND(cond1, cond2), if(cond, true, false), false)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!