Forum Discussion

Luiggi J.'s avatar
Luiggi J.
Copper Contributor
Sep 02, 2018

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 A3 and Finally if it has a value >=17 and <=24 return "Denied in A3"
Any help will be very appreciated.
Thanks

excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Sep 03, 2018

    As variant that could be

    =LOOKUP(A3,{1,9,17,25},{"Approved","Standby","Denied","N/A"})
  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Sep 03, 2018

    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

Resources