multiple ifs with changing variables.

[kristinejaekim]

HI I'm trying to do an if statement and don't know if it's possible. I have 3 columns of data that might change based on if someone wants to participate or not. I need an if statement that allows me to know out of all 3 columns if any 2 of the columns have a value greater than zero give me an output. so column a and b are greater than zero then i want to it say "global", If column b and c are greater than zero than i want it to say global, and if all 3 are greater than zero then say global. any help?

a b c
6 6 0
0 0 5
5 6 6

[Jacc]

In D1 type:

Please Login or Register  to view this content.

and copy down.
What if A and C are greater than zero?

[kristinejaekim]

Hi. yes if a and C are greater than zero then it should say "global"as well. All the variables will be zero at first and if the party decides to participate then they would be a value in greater than zero. so if a,b,c are greater then global, if a and b are greater than global, if a and c are greater than global, if b and c are greater than global. basically if more than 1 party decides to participate then it should say global otherwise just "",I tried your formula but it didn't work. =(

[Jacc]

Sorry about that, too late for thinking.
Try this:

Please Login or Register  to view this content.

Or this:

Please Login or Register  to view this content.