This should be easy, but again i don't have the knowledge to pull it off...
In the attached example col A lists a number of samples, cols B - BB list the results of tests done to the sample. What I would like to do is perform a bunch of if, then, else statements to assign a value to col BC. for example
if cell B3 >=0.5 then cell bc3 = textvalue1
if cell C3 >=.45 then cell bc3 = textvalue2
if cell C3+B3>cell d3 then cell bc3 = textvalue3
if cell K3+Q3+O3 >=1 then cell bc3 = textvalue4
so on and so forth until im out of if then(s)
once it assigns a value to cell BC3 then it would move down to row 4 to assign a value to BC4 using the same if, then, else all the way down until the last record. The number of rows will be variable, could be 5 like the example, could be 500+.
Provided an example I am confident that i could handle all the if then else(s). Assigning the value/result to the cell(s) and handling "variable" number of records is beyond my abilities...