Mar 12 2017
04:43 AM
- last edited on
Jul 25 2018
09:28 AM
by
TechCommunityAP
Mar 12 2017
04:43 AM
- last edited on
Jul 25 2018
09:28 AM
by
TechCommunityAP
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!!!
Mar 12 2017 07:13 AM
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