Results 1 to 4 of 4

multiple ifs with changing variables.

Threaded View

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    huntington beach, ca
    MS-Off Ver
    Excel 2007
    Posts
    2

    multiple ifs with changing variables.

    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
    Last edited by kristinejaekim; 10-09-2012 at 06:17 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1