How do you calculate the qty that multiply with 5 or 10% whichever higher?

[Falinaicare]

Dear Expert,

I need help with excel function. Excel attached.

How do you calculate the qty that multiply with 5 or 10% whichever higher?

Thanks.

 

[Peter Bartholomew]

Total is
= IF( Qty>add/percent, Qty*(1+percent), Qty+add )

 

[Falinaicare]

Dear Peter Bartholomew

Thanks it is working.