need help with a formula

Copper Contributor

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!!!

2 Replies

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

thanks for your help!!!