Forum Discussion

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 =< 5...

Formulas & Functions

Need Help

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

Jim Akers

Copper Contributor

Mar 12, 2017

thanks for your help!!!