Forum Discussion

Jim Akers's avatar
Jim Akers
Copper Contributor
Mar 12, 2017

need help with a formula

I am trying to create a formula and cant seem to figure this one out.  a value is entered in column A and i need a formula in column B that if A<=25 then .5 will appear in the cell. if A>=26 but =< 50 then .35 will appear in the cell. if A >= 51 and <=65 then .25 appears in the cell. if A>65 then 0 appears in the cell. 

 

thanks!!!

Formulas & Functions
Need Help

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 12, 2017

    Hi Jim,

     

    That's classical nested IF with possible alternatives, very good explanations and examples are here https://exceljet.net/nested-ifs

     

    As one of alternative could be

    =SUM(
   (A1<=25)*0.5,
   AND(A1>=26,A1<=50)*0.35
)

    Here are only first two of your conditions, you may add the rest similar way