IF(<Boolean>;<any>;<any>) can you take data from the same sheet in place of "any" as an argument to IF after the boolean expression.

Pallavi Gautam

April 26, 2018 18:35

I want to include data from the same sheet if the boolean condition is satisfied. Is that possible?

0

Comments

2 comments

Alan

April 26, 2018 18:40
Hi Pallavi,

Yes you can certainly do this. The arguments for the IF statement are:

1. IF <Boolean> is True.

2. Then do this.

3. Else do this.

So, for your "Then" condition(the second argument) you would reference the column in question that you want data from.

Let me know if that doesn't clear it up for you,

Alan
0

Comment actions Permalink
Pallavi Gautam

April 26, 2018 18:45
Hey Alan,

That didn't occur to me. Will give that a try. That should work.

Thanks!
0

Comment actions Permalink

Please sign in to leave a comment.