Comparing 2 Columns and returning an answer

Closed
Lenny - Aug 20, 2010 at 07:34 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 24, 2010 at 08:01 AM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 24, 2010 at 08:01 AM
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)
0