Hi
Can you help me in combining 3 statements below in to one line to i can put in one cell.
They work fine on each cell but need to combine.
Ive got one column with "high" "Medium" and "low" in there and one column with numbers in.
=IF(AND(D2 = "High,",I2 > 3),"FAILED High","PASS High")...