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...
Hi Luiggi J.
Give this a whirl in A3 if you are using Office 365:
=IFERROR(IFS(AND(A1>=1, A1<=8), "Approved", AND(A1>=9, A1<=16), "Standby", AND(A1>=17, A1<=24), "Denied"), "Not applicable")
If you are using another veersion of office, use this:
=IF(AND(A1>=1, A1<=8), "Approved", IF(AND(A1>=9, A1<=16), "Standby", IF(AND(A1>=17, A1<=24), "Denied")))
I've attached a file to play with the formula. The key is using AND for the multiple conditions.
Hope that helps you get the idea around it and to have a bit of a test and play?
Cheers
Damien