Forum Discussion
If Formula
Hello. I'm trying to develop a formula in Excell that in cell A3, will look at cell A1, and if >=1 and <=8 return "Aproved" in cell A3, But if it has a value >=9 and <=16 return "Standby" in cell...
As variant that could be
=LOOKUP(A3,{1,9,17,25},{"Approved","Standby","Denied","N/A"})