Posted by Monica on February 06, 2000 11:58 AM
I have a question regarding multiple variables. This is a little complicated so please bear with me. Say column A can have one of 4 different values, column B can have one of 5 different values, and column C can have one of 4 different values as well. All these are different ie A denotes percentages, B denotes numbers, and C denotes abbreviations. Can i set up a formula that produces a result in say column D, if A, B and C together fulfill a particular condition, or yet another value if they don't? There are several combinations that we need to "flag", and i want to set up my spreadsheet so that whenever any of those particular combinations occur, i see a "flag" in column D. Can anyone help me at all? I'd really appreciate it.