IF formula less than greater than and between 2 value

Hi Experts,

I need to help in formula in cell B3, When I changes the amount in Cell B1 then the calculations in B3 needs to calculate according to above formula.

Criteria:
if amount is less than B5 = 0
If amount is between B5 and B6 = (amount - B5) x c2
If amount is greater than B6 = B6 x c2


Thanks in advance

This gives you what you asked for in post #1:

=IF(B1<B5,0,IF(AND(B1>=B5,B1<=B6),(B1-B5)*C2,B6*C2))

Maybe

Formula:

Please Login or Register  to view this content.

beaten2it

63falcondude Thank you very much your given formula is working perfectly, you are awesome.

Happy to help.

Thanks for the rep!

welcome 63flcondude, I need some modification in that formula:
If the amount in cell B1 is greater than 18000 then the calculation that we have i.e
If amount is greater than B9 = B9 x E2 should cap (not exceed 720)

How about

Formula:

Please Login or Register  to view this content.

Thank you fluff13 you are great.

You're welcome & thanks for the feedback