Forum Discussion

corinne2510's avatar
corinne2510
Copper Contributor
Jul 04, 2024
Solved

Multiple IF in one cell

Hi   I need some assistance writing a formula with the following specifics:   "If A1 contains a value lower than 59% then return 0, and if A1 contains a value greater than 59% but lower than 75% ...
excel
Formulas and Functions
  • Martin_Angosto's avatar
    Martin_Angosto
    Jul 04, 2024

    corinne2510 

    Try this:

     

    =IF(A1<59%,0,IF(AND(A1>59%,A1<75%),1,IF(AND(A1>74%,A1<85%),2.5,IF(A1>84%,5,""))))

Kadarshah's avatar
Kadarshah
Copper Contributor
Jul 04, 2024

You can try this formula =IF(A1<0.59, 0, IF(A1<0.75, 1, IF(A1<0.85, 2.5, 5)))

Resources